> > >

Microsoft SQL Server MCQs

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 job='clerk' or job='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 job='clerk' or job='salesman')

Explanation:

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

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it