SQL Plus Interview Question:

Explain What is meant by SORTING and GROUPING?

Submitted by: Administrator

For sorting we use order by clause in select statement. This is used to sort data in ascending order or descending order.
To group data based on perticulr column we use groupby clause.
Both are used to get distinct values.
Submitted by: Administrator