SQL Plus Question:
Download Job Interview Questions and Answers 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.
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 Question | Next Question |
| Explain How do we eliminate the duplicate rows? | Explain What is the maximum number of triggers, can apply to a single table? |