單項(xiàng)選擇題

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

你可能感興趣的試題

單項(xiàng)選擇題

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.

單項(xiàng)選擇題

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

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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

你可能感興趣的試題

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

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（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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（）