The Oracle server implicitily sort the ResultSet in ascending order by using Group By clause .
Order by is to sort ResultSet either in ascending or descending order .
Which statements are true about Group By ?
How to select Maximum Salary of Employee from each Department ?
'Having' clause is used with
What is the correct format to select Emp_name in Ascending order ?
How o select number of employee department wise from Emp table ?
Which of the following is correct to count the total salary in deptno wise where more than two employees exist ?
Both 'having' and 'where' clause can be used in aggregate functions.