> > >

MySQL MCQs

Consider the following Table EMP: --------------- empId empName empSalary empJoinDate Which SQL is incorrect for finding out the count of records on EMP table where empJoinDate is between 2012-10-01 and 2012-12-30?

Select count(*) from EMP where empJoinDate between '2012-10-01' and 2012-12-30';

Select count(1) from EMP where empJoinDate between '2012-10-01' and 2012-12-30';

Select count(*) from EMP where empJoinDate between '2012-10-01' and 2012-12-30' group by EXTRACT(YEAR_MONTH from empJoinDate );

Select sum(1) from EMP where empJoinDate >="2012-10-01" and empJoinDate <="2012-12-30";

Non of the above

Answer

Correct Answer: Select count(*) from EMP where empJoinDate between '2012-10-01' and 2012-12-30' group by EXTRACT(YEAR_MONTH from empJoinDate );

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it