查询各类别的公司中比该类别最小工资高300元的公司、工资、类别
A: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type GROUP BY type) ;
B: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type ) + 300;
C: SELECT name, salary, type FROM job WHERE salary > 300;
D: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type GROUP BY type) + 300;
A: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type GROUP BY type) ;
B: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type ) + 300;
C: SELECT name, salary, type FROM job WHERE salary > 300;
D: SELECT name, salary, type FROM job AS s1 WHERE salary > (SELECT min(salary) FROM job AS s2 WHERE s1.type = s2.type GROUP BY type) + 300;
举一反三
- 如果除了月工资，年终还发放全年工资的40%作为年终奖，计算每个公司的年收入( ) A: SELECT name, salary*(12+ salary*12*0.4) FROM job; B: SELECT name, salary*12+ 0.4 FROM job; C: SELECT name, salary*12+ salary*0.4 FROM job; D: SELECT name, salary*12+ salary*12*0.4 FROM job;
- 如果每月除了固定工资还有600元交通补贴，查找在各个公司的每个月总收入 A: SELECT salary+600 FROM job; B: SELECT name, salary+600 FROM job; C: SELECT name+600, salary FROM job; D: SELECT name, salary add 600 FROM job;
- 以下语句错误的是() A: LECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; B: SELECT rank, AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000 C: SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; D: SELECT AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000; E: SELECT rank, AVG(salary) FROM people GROUP BY rank WHERE AVG(salary) > 1000;
- 表employees中有字段title表示职务，字段salary表示工资，求各个职务平均工资的T-SQL语句是（ ）。 A: SELECT AVG(SALARY) FROM EMPLOYEES WHERE TITLE B: SELECT AVG(SALARY) FROM EMPLOYEES GROUP BY TITLE C: SELECT AVG(TITLE) FROM EMPLOYEES GROUP BY SALARY D: SELECT SALARY FROM EMPLOYEES GROUP BY TITLE
- 设有职工基本表：EMP(ENO，ENAME，AGE，SEX，SALARY)，其属性分别表示职工号、姓名、年龄、性别、工资。为每个工资低于平均工资的女职工加薪200元，以下SQL语句正确的是______。 A: UPDATE EMP SET SALARY=SALARY+200 B: WHERE SALAEY＜(SELECT AVG(SALARY)FROM EMP) AND SEX=’女’ C: UPDATE FROM EMP SET SALARY=200 D: WHERE SALAEY＜(SELECT SUM(SALARY)FROM EMP)AND SEX=’女’ E: UPDATE EMP SET SALARY=200 F: WHERE SALAEY＜(SELECT AVG(SALARY)FROM EMP)AND SEX=’女’ G: UPDATE FROM EMP SET SALARY=SALARY+200 H: WHERE SALAEY＜(SELECT SUM(SALARY)FROM EMP)AND SEX=’女’