Question

Differentiate between Where and Orderby clause of SQL statements.

Answer 1

Answer:

In group by clause, the tuples are grouped based on the similarity between the attribute values of tuples. Whereas in order by clause, the result-set is sorted based on ascending or descending order.

Answer 2

The SQL WHERE statement restricts the number of records that an operation can return or effect. To arrange the result set in lowest to highest, use the ORDER BY keyword.

Differentiate between WHERE and ORDERBY clause :

WHERE clause of SQL statements.

• The SQL WHERE statement restricts the number of records that an operation can return or effect. The SELECT, UPDATE, & DELETE clauses are all used with it.

• You can just use the AND keywords to express several requirements that your command's records must satisfy.

ORDERBY clause of SQL statements.

• To arrange the result set in lowest to highest, use the ORDER BY keyword. By default, the ORDER BY command arranges the entries in ascending order.

• The SQL ORDER BY command sorts the obtained data in upward or downward order based on one or more attributes.