题目内容
（请给出正确答案）
A.Select*From Tab1 Where简历Like“篮球”
B.Select*From Tab1 Where简历Like“*篮球”
C.Select*From Tab1 Where简历Like“*篮球*”
D.Select*From Tab1 Where简历Like“篮球*”
如果结果不匹配，请 联系老师 获取答案
更多“与语句Select*From Tab1 Where Inst…”相关的问题
Customers1与Customers2表结构一致，以下SQL语句正确的有（)。
A、SELECT cust_name FROM Customers1 UNION SELECT cust_name FROM Customers2
B、SELECT cust_contact FROM Customers1 UNION SELECT cust_name, cust_contact FROM Customers2
C、SELECT * FROM Customers1 UNION SELECT * FROM Customers2
D、SELECT cust_name FROM Customers1 UNION SELECT * FROM Customers2
A.SELECT*FROM教师WHERE工资BETWEEN2000AND3000
B.SELECT*FROM教师WHERE工资＞2000AND工资＜3000
C.SELECT*FROM教师WHERE工资＞2000OR工资＜3000
D.SELECT*FROM教师WHERE工资＜=2000AND工资＞=3000
设有关系R(A，B，C)和S(C，D)与SQL语句SELECT A，B，D FROM R，S WHERE R.C=S.C等价的关系代数表达式是
A．σR.C=S.C(πA,B,D(R×S))
B．πA,B,D(σR.C-S.C(R×S))
C．σR.C=S.C((πA,BR)×(πDS))
D．σR.C=S.C(πD((πA,BR)×S)
A.select*from A a left join B b on a.bid=b.bid
B.select*from A a right join B b on a.bid=b.bid
C.select*from A a inner join B b on a.bid=b.bid
D.select*from A a inner join B b where a.bid=b.bid
SQL语句： SELECT*FROM仓库表WHERE NOT EXISTS； (SELECT*FROM职工表WHERE仓库号=仓库.仓库号) 该语句等价于： SELECT*FROM仓库表WHERE仓库号 (SELECT仓库号FROM职工表)
语句“USE master GO SELECT * FROM sysfiles GO”包括()个批处理。
A.1
B.2
C.3
D.4
SQL语句，以下语句不会导致全表扫描的是（)。
A、select id from t where substring(name, 1,3)='cif'
B、select id from t where name like 'cif%'
C、select id from table_1 where num=10 or num=20
D、select id from t where createdate＞='20 05-11-30' and createdate＜'2005-12-1'
