Curioustab

Home » Database » Introduction to SQL

DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.

True
False

Correct Answer: False

← Previous Question Next Question→

More Questions from Introduction to SQL

SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
There is an equivalent join expression that can be substituted for all subquery expressions.
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
The result of every SQL query is a table.
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
ORDER BY can be combined with the SELECT statements.
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion