SQL Plus Question:
Download Questions PDF

Explain What is meant by SORTING and GROUPING?

Answer:

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.

Download SQL Plus Interview Questions And Answers PDF

Previous QuestionNext Question
Explain How do we eliminate the duplicate rows?Explain What is the maximum number of triggers, can apply to a single table?