SQL Group By Order By and Having

The Oracle server implicitily sort the ResultSet in ascending order by using Group By clause .

true

false

Order by is to sort ResultSet either in ascending or descending order .

true

false

Which statements are true about Group By ?

Group By is used to group set of values based on one or more values

Group By is used when we use aggregate functions

Group by does not guaranteed sorts the data in any order

All of above

How to select Maximum Salary of Employee from each Department ?

Select deptno, sal from Emp Group By deptno Order By Max(Sal);

Select dept_id, sal from Emp Group By dept_id Order By Max(Sal);

Select deptno, max(sal) from Emp Group By deptno;

'Having' clause is used with

Group By

Order By

Both of above

What is the correct format to select Emp_name in Ascending order ?

Select Emp_name From Emp ;

Select Emp_name From Emp Group By Emp_name ;

Select Emp_name From Emp Order By Emp_name ;

All of above

What is the correct format to select Emp_name in Ascending order ?

Select Emp_name From Emp ;

Select Emp_name From Emp Group By Emp_name ;

Select Emp_name From Emp Order By Emp_name ;

All of above

How o select number of employee department wise from Emp table ?

Select deptno, count(*) from Emp Group By deptno;

Select empno,deptno, count(*) from Emp Group By deptno;

Select deptno, count(*) from Emp Order By deptno;

Select empno, count(*) from Emp Order By deptno;

Which of the following is correct to count the total salary in deptno wise where more than two employees exist ?

SELECT deptno, sum(sal) As totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) = 2

SELECT deptno, sum(sal) As totalsal FROM emp GROUP BY deptno where COUNT(empno) = 2

SELECT deptno, sum(sal) As totalsal
FROM emp
GROUP BY deptno
HAVING COUNT(empno) > 2

SELECT deptno, sum(sal) As totalsal FROM emp GROUP BY deptno where COUNT(empno) > 2

Both 'having' and 'where' clause can be used in aggregate functions.

true

false