what is the difference between group by and order by?
Submitted by: Administratorgroup by is used when we use aggregate functions on the columns in a query the other columns
should be in group by query
example:
select empno,ename,sum(sal) from emp
group by empno,ename
Order by is used to sort values either in ascending or descending order
Submitted by: Administrator
should be in group by query
example:
select empno,ename,sum(sal) from emp
group by empno,ename
Order by is used to sort values either in ascending or descending order
Submitted by: Administrator
Read Online Oracle DBA Job Interview Questions And Answers
Top Oracle DBA Questions
☺ | What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other? |
☺ | When using Oracle export/import what character set concerns might come up? How do you handle them? |
☺ | Explain FORCE LOGGING feature in 9i. |
☺ | Name three SQL operations that perform a SORT. |
☺ | What is the difference between RAID 5 and RAID 10? Which is better for Oracle? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |