Discussion :: SQL Basics
- 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?
|
A.
SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; |
|
B.
SELECT name FROM staffinfo WHERE salary IN (10000, 25000); |
|
C.
Both A and B |
|
D.
None of the above |
Answer : Option B
Explanation :
Explanation Not Provided
Be The First To Comment

Whatsapp
Facebook