adplus-dvertising
frame-decoration

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?

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

Posted under DBMS

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

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

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?

Similar Questions

Discover Related MCQs

Q. Select the right statement to insert values to the student table.

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

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

Q. 'AS' clause is used in SQL for

Q. The type of function which allows performing additional operations and sending messages to other tables in database program is considered as

Q. The technique in which source program are replaced by database management generated code is classified as

Q. In database management systems, the record which contains all the data regarding tuples of database is called

Q. The database program which handles software applications and include database servers calls to update the data is classified as

Q. The database interface in which the data is directly entered into the monitor is classified as

Q. The type of iterator which is used to list the types of attributes that are included in the query result is called

Q. In query result, the type of variable which is used to loop tuples is called

Q. The variable in DBMS used to communicate error conditions between database management system and program are

Q. In database management system, if the cursor is to be moved to next rows in queries result then the command is classified as

Q. The general purpose programming languages such as COBOL and ADA is classified as

Q. The kind of record which is used to keep the information of specific database connection is classified as

Q. In multiple tuples retrieval, the command which is used to fetch queries from database is classified as

Q. If the completion of processing is to be shown then the command which is used for this purpose is called

Q. In database management systems, the record which contains all the information needed for one statement of standard query language is called

Q. In SQL standard, the variable which is considered as communication variable and is string of five characters is named as

Q. The device which scans program code and extract them from database management system for processing is classified as