Question

differentiate between where and order by clause of SQL staments​

Answer 1

Answer:

S.NO GROUP BY

3. In select statement, it is always used before the order by keyword.

4. Attribute cannot be in the group by statement under aggregate function.

5. In group by clause, the tuples are grouped based on the similarity between the attribute values of tuples