正在加载图片...
hidden, or turn off the display. Finally, you can make it move off the page, or move another element in front of it (4)Fill in the blanks (a) Red (b)Teal (c) Purple (d) Gray (e)olive (5)SQL Sta (a)SELECT employee employee-name, works. salary FROM employee, works WHERE employee employee- or SELECT employee-name, salary FROM works (b)SELECT employee employee-name FROM employee, works, branch WhERE employee. city works city and works. branch-name= branch branch-name and employee employee-name works employee-name (c)selECT branch-name, COUNT()as numbers FROM works GROUP BY branch-name ORDER BY numbers DESC LIMit 1 (d) UPDATE employee SeT city ='Beijing'WhERE employee-name = Jones (e) UPDATE works SET salary salary *1. I WhERE salary * 1. 1 <=120000 UPDATE works SET salary salary*1.03 WHERE salary *1. 1>120000hidden, or turn off the display. Finally, you can make it move off the page, or move another element in front of it. (4) Fill in the blanks (a) Red (b) Teal (c) Purple (d) Gray (e) Olive (5) SQL statements (a) SELECT employee.employee-name, works.salary FROM employee, works WHERE employee.employee- name = works.employee- name or SELECT employee-name, salary FROM works (b) SELECT employee.employee-name FROM employee, works, branch WHERE employee.city = works.city and works.branch-name = branch.branch-name and employee.employee-name = works.employee-name (c) SELECT branch-name, COUNT(*) as numbers FROM works GROUP BY branch-name ORDER BY numbers DESC LIMIT 1 (d) UPDATE employee SET city = 'Beijing' WHERE employee-name = 'Jones' (e) UPDATE works SET salary = salary * 1.1 WHERE salary * 1.1 < = '120000' UPDATE works SET salary = salary * 1.03 WHERE salary * 1.1 > '120000
<<向上翻页
©2008-现在 cucdc.com 高等教育资讯网 版权所有