level 4
请问各位你们的zuk z2支持otg吗?买了otg却无法识别。商家说它的东西没问题是你的手机不支持。如果有支持的请放个视频,我拿去要商家退货。
2019年11月10日 04点11分
1
level 3
AND B.C
#='C4' AND C.C#
='C8';
5 SELECT A.E#, A.ENAME
FROM EMP A, WORKS B, COMP C
WHERE A.E#=B.E
# AND B.C#
=C.C#
AND CNAME='E#O E' ANDSAL ARY> 1000
AND SEX='M';
6 SELECT E
#, COUNT(C#
) AS NUM,SUM(SAL ARY) AS SUM_ SALARY
FROM WORKS
GROUP BY E#;
O SELECT X.E#
FROM WORKS X
WHERE NOT EXISTS
(SELECT *
FROM WORKS Y
WHERE E#-'E6'
AND NOT EXISTS
(SELECT *
FROM WORKS Z
WHERE Z.E#=X.E#
AND Z.C#=Y.C#)):
8 SEL ECT A.E#, A.ENAME
FROM EMP A, WORKS B, COMP C
WHERE A.E#=B.E
# AND B.C#
=C.C#
AND CNAME='EX-#V a'
AND SALARY<(SELECT AVG(SAL ARY)
FROM WORKS, COMP
WHERE WORKS.C#=COMP.C#
AND CNAME='E15bB') :
9UPDATE WORKS
SET SAL ARY=SAL ARY+100
WHERE E# IN (SEL ECT E# FROM EMPWHERE AGE>50);
DEL E TE FROM WORKS
WHERE E# IN (SELECT E# FROM EMPWHERE AGE>60);
DEL ETE FROM EMP
WHERE AGE>60;
2019年11月14日 03点11分
4