Explain What is meant by SORTING and GROUPING?
Submitted by: AdministratorFor 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
To group data based on perticulr column we use groupby clause.
Both are used to get distinct values.
Submitted by: Administrator
Read Online SQL Plus Job Interview Questions And Answers
Top SQL Plus Questions
☺ | Explain ROWID? |
☺ | What is a join in Oracle? Explain the different types of joins? |
☺ | Explain Explicit Cursor attributes? |
☺ | How to use SQL to build SQL, what is this called and give an example? |
☺ | Explain How do we eliminate the duplicate rows? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |