> > >

MySQL MCQs

Which query will display data from the Pers table relating to Analyst, Clerk and
Salesman who joined between 1/1/2005 and 1/2/2005 ?
Which query will display data from the Pers table relating to Analysts, Clerks and Salesmen who joined
between 1/1/2005 and 1/2/2005 ?

select * from Pers where joining_date from #1/1/2005# to #1/2/2005#, job=Analyst or clerk or salesman

select * from Pers where joining_date between #1/1/2005# to #1/2/2005#, job=Analyst or job=clerk or job=salesman

select * from Pers where joining_date between #1/1/2005# and #1/2/2005# and (job=Analyst or clerk or salesman)

None of the above

Answer

Correct Answer: select * from Pers where joining_date between #1/1/2005# and #1/2/2005# and (job=Analyst or clerk or salesman)

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