单项选择题
Given that tables T1 and T2 contain the following rows: Table T1:
C1 C2
5 4 5 2 5 5
Table T2: C1 C2 5 1 5 2 5 3
Which of the following queries will return only those rows that exist in T1 and not in T2?（）
A.SELECT * FROM T1 MINUS SELECT * FROM T2
B.SELECT * FROM T1 EXCEPT SELECT * FROM T2
C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
相关考题
-
单项选择题
How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END（）
A.CALL getratews11('USA','CANADA')
B.CALL expenses.getratews11('USA','CANADA')
C.SELECT getratews11('USA','CANADA') FROM expenses
D.SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency -
单项选择题
Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statement? SELECT location FROM continents, region（）
A.2
B.7
C.9
D.14 -
单项选择题
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
