The following query fails. Select employee_name,employee_id,count() from employee_Details group by employee_id where count()>2; The right format is:

  1. Select employee_name,count() from employee_Details group by employee_id where count()>2;

  2. Select employee_name,employee_id,count() from employee_Details group by employee_id having count()>2;

  3. Select employee_name,employee_id,count() from employee_Details order by employee_id where count()>2;

  4. NONE of THE ABOVE


Correct Option: B

Find more quizzes: