Curioustab

Home » Database » Introduction to SQL

The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

True

Correct Answer: True

← Previous Question Next Question→

More Questions from Introduction to SQL

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.
To establish a range of values, < and > can be used.
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
The condition in a WHERE clause can refer to only one value.

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion