Q:

Which of the following SQL query is correct for selecting the name of staffs from \'staffinfo\' table where salary is 10,000 or 25,000?

mhmadesk

Save to bookmark

|

2022-07-08

|

384

Medium

0

Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000?

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;
SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
Both a and b
None of the above

Database, MCQ Questions, Database MCQ-questions,

login and add your own answer to this question

All Answers

mhmadesk

2022-07-08

need an explanation for this answer? contact us directly to get an explanation for this answer

(b).SELECT name FROM staffinfo WHERE salary IN (10000, 25000);

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)