Oracle DBA Question:
Download Job Interview Questions and Answers PDF
what is the difference between group by and order by?
Answer:
group 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
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
Download Oracle DBA Interview Questions And Answers
PDF