adplus-dvertising
frame-decoration

Question

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

a.

ONLY

b.

UNIQUE

c.

DISTINCT

d.

SINGLE

Posted under DBMS

Answer: (c).DISTINCT

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

Similar Questions

Discover Related MCQs

Q. SQL query and modification commands make up a(n) ________ .

Q. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

Q. The Microsoft Access wildcards are ____ and ____ .

Q. Find the SQL statement below that is equal to the following:
SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

Q. To sort the results of a query use:

Q. To define what columns should be displayed in an SQL SELECT statement:

Q. SQL can be used to:

Q. The SQL statement that queries or reads data from a table is ________ .

Q. The SQL keyword BETWEEN is used:

Q. A subquery in an SQL SELECT statement:

Q. ________ was adopted as a national standard by ANSI in 1992.

Q. SQL is:

Q. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

Q. Which of the following SQL statements are helpful in database redesign?

Q. What SQL command can be used to delete columns from a table?

Q. Which SQL-92 standard SQL command can be used to change a table name?

Q. How can you find rows that do not match some specified condition?

Q. A regular subquery can be processed:

Q. What SQL command can be used to add columns to a table?

Q. The EXISTS keyword will be true if: