Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 7818 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
What is your daily office routine?
Is primary key always clustered index?
what is dbms? : Sql dba
Is inner join faster than left join?
Can we rollback truncate?
how to escape special characters in sql statements? : Sql dba
how to start mysql server? : Sql dba
what is bcp? When does it used? : Sql dba
What is the best sql course?
Do we need to rebuild index after truncate?
what is sql server agent? : Sql dba
what is collation? : Sql dba
How do I remove duplicates in two columns?
What is the current version of sql?
how many tables will create when we create table, what are they? : Sql dba
