having clause with sub queries first we have to


Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department.

SELECT DEPTNO, MIN (SAL)

FROM.EMP

GROUP BY DEPTNO;

Output:

DEPTNO

SAL

10

2975

20

3000

 

Request for Solution File

Ask an Expert for Answer!!
Database Management System: having clause with sub queries first we have to
Reference No:- TGS0209937

Expected delivery within 24 Hours