> > >

ASP.NET With 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 '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

ASP.NET With SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More ASP.NET With SQL Server MCQ Questions

ASP.NET With SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it