News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

Advertisement

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;

Employee

---------

Empno

Employeename

Salary

Deptno

Department

---------

Deptno

Departname

  1. Select departname from department where deptno in (select deptnofrom employee group by deptno having count(*) > 100);

  2. Select departname from department where deptno in (select count(*)from employee group by deptno where count(*) > 100);

  3. Select departname from department where count(deptno) > 100;

  4. Select departname from department where deptno in (select count(*)from employee where count(*) > 100);

Answer: Answer is a
Further Reading:

Other option (except a) will not execute due to error in the statement. Useful resources, SQL basic queries, query fundamental, HAVING Clause, COUNT, SQL IN

comments powered by Disqus
Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;