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? Options: A . &nbspSELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; B . &nbspSELECT name FROM staffinfo WHERE salary IN (10000, 25000); C . &nbspBoth A and B D . &nbspNone of the above

Which of the following SQL query is correct for selecting the name of staffs fro

Question

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?

Options:

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

Submit Your Solution Below and Earn Points !

Next Question

Question 1. Select the right statement to insert values to the student table.....

Question 2. ............. joins two or more tables based on a specified column value not equaling a specified column value in anothe....value not equaling a specified column value in another table.

Question 3. In SQL, which command is used to change a table's storage characteristics?....

Question 4. In SQL, which of the following is not a data definition language commands?....

Question 5. 'AS' clause is used in SQL for....

Question 6. Count function in SQL returns the number of....

Question 7. NULL is....

Question 8. Which of the following is a valid SQL type?....

Question 9. What is the full form of SQL?....

Question 10. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI

Tabulation - Test Paper 2 Data Interpretation Reasoning & DI

Test Paper 1 Direction Sense Test Reasoning & DI

ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0

GFM Combined 1 Free Revision Test SAIL JO E-0