Ans-1: SELECT DEPTNO, COUNT(*) FROM EMP GROUP BY DEPTNO HAVING COUNT(*

Q1.all the depts which has more then 10 empls?
Q2.all the dept which does not have any emply?
Q3 all the emp which does not have any dept?
Q4 get all the emply detais with the dept details it dept is
exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?

Question Posted / ramya pisharody

4 Answers
7485 Views
KPIT, I also Faced
E-Mail Answers

Answer Posted / ramya pisharody

Ans-1:

SELECT DEPTNO, COUNT(*) FROM EMP
GROUP BY DEPTNO
HAVING COUNT(*)>10;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger types in sql?

959

What is sql table?

922

What is the difference between alter trigger and drop trigger statements?

1061

What is before trigger?

956

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

960

What are all different types of collation sensitivity?

990

Explain sql data types?

1047

what is normalization? : Sql dba

1039

What is sharding in sql?

935

What is sql*loader?

1103

how to increment dates by 1 in mysql? : Sql dba

943

Can we insert in sql function?

1038

What is foreign key in sql with example?

901

What is the difference between microsoft sql and mysql?

934

What is nvarchar in sql?

894