Introduction to SQL
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?
Both A and B
SELECT name FROM staffinfo WHERE salary IN (10000, 25000);
SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;
EXAMIANS