单项选择题

Which of the following statements eliminates all but one of each set of duplicate rows in the DEPT column in the STAFF table?（）

A.SELECT UNIQUE dept FROM staff
B.SELECT DISTINCT dept FROM staff
C.SELECT (dept) UNIQUE FROM staff
D.SELECT (dept) DISTINCT FROM staff

点击查看答案

上一题目录下一题

相关考题

单项选择题

In which of the following situations should correlation names be used?（）

A.A table referenced in the FROM clause has no indexed column.
B.The table referenced in the FROM clause has more than 200 columns.
C.Two or more tables in the FROM clause have identical column names.
D.The FROM clause contains two or more tables in the SELECT statement.

单项选择题

Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL
CLERK 3
If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1（）

A.0
B.1
C.3
D.6

单项选择题

Which of the following is a feature of a unit of work?（）

A.It applies to a single data server.
B.It is a recoverable sequence of operations.
C.Its value can be queried from the system catalog tables.
D.It begins when the application connects to the data server.