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.

;
rollno        int 
name          varchar(20) 
course        varchar(20) 

What will be the query to display the courses in which the number of students enrolled is more than 5?

  1. Select course from students where count(course) > 5;

  2. Select course from students where count(*) > 5 group by course;

  3. Select course from students group by course;

  4. Select course from students group by course having count(*) > 5;

  5. Select course from students group by course where count(*) > 5;

  6. Select course from students where count(group(course)) > 5;

  7. Select count(course) > 5 from students;

  8. None of the above

Answer: Answer is d
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.

;