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?

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?

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

Both A and B

None of these

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 these

SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following is valid SQL for an Index?

ADD INDEX ID;

CREATE INDEX ID;

CHANGE INDEX ID;

REMOVE INDEX ID;

ADD INDEX ID;

CREATE INDEX ID;

CHANGE INDEX ID;

REMOVE INDEX ID;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
A subquery in an SQL SELECT statement:

can always be duplicated by a join.

cannot have its results sorted using ORDER BY.

has a distinct form that cannot be duplicated by a join.

can only be used with two tables.

can always be duplicated by a join.

cannot have its results sorted using ORDER BY.

has a distinct form that cannot be duplicated by a join.

can only be used with two tables.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

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?

Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Introduction to SQL Which of the following is valid SQL for an Index?

Introduction to SQL A subquery in an SQL SELECT statement:

Introduction to SQL If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.

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?

Introduction to SQL
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

Introduction to SQL
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

Introduction to SQL
Which of the following is valid SQL for an Index?

Introduction to SQL
A subquery in an SQL SELECT statement:

Introduction to SQL
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.