sql练习(国外英语资料).docVIP

  • 45
  • 0
  • 约1.01万字
  • 约 31页
  • 2017-06-24 发布于河南
  • 举报
sql练习(国外英语资料)

sql练习 Second chapters 1. displays all the information for department tables SELECT * FROM departments; 2. display department number, department name SELECT department_id, Department_name FROM departments; 3. displays the following field and string connections: employee name, 1 months salary: salary. Such as: Amy 1 months salary: 8000 SELECT first_name||||last_name|| a months salary is:||salary FROM employees; 4. show the employees name, work time and work SELECT first_name, Hire_date, Job_id FROM employees emp; 5. display employee name: alias Name, annual salary (13 months monthly salary): ali

文档评论(0)

1亿VIP精品文档

相关文档