你可能感兴趣的试题
DROP salary VIEW DROP VIEW salary DELETE salary VIEW DELETE salary
postman product policeman boss
in the face of in need of in favor of in terms of
in need of in spite of in terms of in favor of
DROP salary VIEW DROP VIEW salary DELETE salary VIEW DELETE salary
offered will be offered are offered offer
in need of in face of in favor of in terms of
DROP salary VIEW DROP VIEW salary DELETE salary VIEW DELETE salary
DROP salary VIEW DROP VIEW salary DELETE salary VIEW DELETE salary
SALARY≤2000ANDSALARY≥1000 SALARY<2000ANDSALARY>1000 SALARY=1000ANDSALARY=2000 SALARY=1000ORSALARY=2000
SM1,SM3 SM2,SM3 SM3,SM1 SM1,SM2
UPDATE EMP SET SALARY=SALARY+200 WHERE SALAEY<(SELECT AVG(SALARY)FROM EMP) AND SEX=’女’ UPDATE FROM EMP SET SALARY=200 WHERE SALAEY<(SELECT SUM(SALARY)FROM EMP)AND SEX=’女’ UPDATE EMP SET SALARY=200 WHERE SALAEY<(SELECT AVG(SALARY)FROM EMP)AND SEX=’女’ UPDATE FROM EMP SET SALARY=SALARY+200 WHERE SALAEY<(SELECT SUM(SALARY)FROM EMP)AND SEX=’女’
except in addition to thanks to in terms of
must make could have made should have made would make
ORDER BY SALARY>5000 GROUP BY SALARY>5000 HAVING SALARY>5000 WHERE SALARY>5000
my half of month salary my half salary month half monthly my salary half of my monthly salary
offered will be offered are offered offer
SALARY≤2000 AND SALARY≥1000 SALARY<2000 AND SALARY>1000 SALARY=1000 AND SALARY=2000 SALARY=1000 OR SALARY=2000
UPDATE EMP SET SALARY=SALARY+200 WHERE SALAEY<(SELECT AVG(SALARY)FROM EMP) AND SEX=’女’ UPDATE FROM EMP SET SALARY=200 WHERE SALAEY<(SELECT SUM(SALARY)FROM EMP) AND SEX=’女’ UPDATEEMP SET SALARY=200 WHERE SALAEY<(SELECT AVG(SALARY)FROM EMP) AND SEX=’女’ UPDATE FROM EMP SET SALARY=SALARY+200 WHERE SALAEY<fSELECT SUM(SALARY)FROM EMP) AND SEX=’女’