Question: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 ? 

A select * from Pers where joining_date from '1/1/2005' to '1/2/2005', job='Analyst' or 'Clerk' or 'Salesman' 

B select * from Pers where joining_date between '1/1/2005' to '1/2/2005', job='Analyst' or job='Clerk' or job='Salesman' 

C select * from Pers where joining_date between '1/1/2005' and '1/2/2005' and (job='Analyst' or 'Clerk' or 'Salesman') 

D None of these above 

+ Answer
+ Report
Total Preview: 21251

Copyright © 2024. Powered by Intellect Software Ltd