A、SELECT * FROM t1 UNION SELECT * FROM t2
B、SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
C、SELECT * FROM t1 INTERSECT SELECT * FROM t2
D、SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
更多“ Given that tables T1 and T2 contain the following rows:<br /> Table T1: C1 C2 1 4 1 3 1 2<br /> Table T2: C1 C2 1 1 1 2 1 3<br /> Which of the following queries will return only those rows that exist in both T1 and T2?（）”相关的问题
A、A.SELECT * FROM T1 MINUS SELECT * FROM T2 B、B.SELECT * FROM T1 EXCEPT SELECT * FROM T2 C、C.SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1 D、D.SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
A、A.mean low water B、B.the same as that used for the charts of the locality C、C.the highest possible level D、D.given in table three of the tide tables
A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
A、ALTER TABLE test ADD t_sex CHAR（2） B、ALTER TABLE test ADD t_sex C、ALTER TABLE test ALTER t_sex CHAR（2） D、ALTER TABLE test DROP（t_sex CHAR（2））
A、ALTER TABLE T ADD COLUMN c1 int B、ALTER TABLE T ADD （c1 int） C、ALTER TABLE T ADD COLUMN c1 D、ALTER TABLE T ADD c1
A、Delete the default auth table mapping policy B、Create auth table mapping policies that route users to specific resources C、Create Resource Access policies that permit access to specific resources D、Create Source Interface policies that route users to specific resources
A、Any row inserted or updated through view V1 must meet the condition that col4 > 1000. B、From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked. C、At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected. D、Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.
客服
TOP
查看正确答案
