相关考题
-
单项选择题
给定下列两个表:()。
A.SELECT * FROM tab1 INNER JOIN tab2 ON col_1 = col_a
B.SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 = col_a
C.SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 = col_a
D.SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 = col_a -
单项选择题
给定下列两个表 使用下列语句将返回多少行?() SELECT distinct student_name FROM names, marks
A.9
B.20
C.5
D.6 -
单项选择题
给定下列表: 下列哪一个语句会产生所需结果?()
A.SELECT UNIQUE * FROM tab1
B.SELECT DISTINCT * FROM tab1
C.SELECT UNIQUE(*) FROM tab1
D.SELECT DISTINCT(*) FROM tab1
