UC知道关于DB2的一些问题
来源：百度知道 编辑：UC知道 时间：2024/05/25 07:19:39
问题一
List employee number,last name,date of birth,and salary for all employees who make more than $30000 a year.Sequence the results in descending order by salary.
以下是给出的答案
SELECT EMPNO,LASTNAME,BIRTHDATE,SALARY
FROM ADMINISTRATOR.EMPLOYEE
WHERE SALARY>30000
ORDER BY SALARY DESC;
所以下边再给出一道题，希望能有类似上边的解答
List last name,and the department number for all employees.The listing should be ordered by descending department numbers.Within the same departments,the last names should be sorted in descending order.
谢啦哈~
拜托拜托，千万不要说我贪得无厌啊。。。我是真不会才来求助的，主要是，还有好几题啦。。。麻烦好心的大哥啦（如果是大哥的话。。。）
这是第三题
List all projects that have SUPPORT as part of the project name.Order the results by project number.
第四题
List all departments that have a 1 as the middle character in the department number.Order the results by department number.
第五题
For all projects that have a project number beginning with AD,list proje
List employee number,last name,date of birth,and salary for all employees who make more than $30000 a year.Sequence the results in descending order by salary.
以下是给出的答案
SELECT EMPNO,LASTNAME,BIRTHDATE,SALARY
FROM ADMINISTRATOR.EMPLOYEE
WHERE SALARY>30000
ORDER BY SALARY DESC;
所以下边再给出一道题，希望能有类似上边的解答
List last name,and the department number for all employees.The listing should be ordered by descending department numbers.Within the same departments,the last names should be sorted in descending order.
谢啦哈~
拜托拜托，千万不要说我贪得无厌啊。。。我是真不会才来求助的，主要是，还有好几题啦。。。麻烦好心的大哥啦（如果是大哥的话。。。）
这是第三题
List all projects that have SUPPORT as part of the project name.Order the results by project number.
第四题
List all departments that have a 1 as the middle character in the department number.Order the results by department number.
第五题
For all projects that have a project number beginning with AD,list proje
SELECT LASTNAME,DEPTNUMBER
FROM ADMINISTRATOR.EMPLOYEE
ORDER BY LASTNAME DESC,DEPTNUMBER;
SELECT PROJECTNAME FROM PROJECT WHERE PROJECTNAME = '%SUPPORT%' ORDER BY PROJECTNUM
SELECT PROJECTNAME FROM PROJECT WHERE PROJECTNUM = '_%1%_' ORDER BY PROJECTNUM
SELECT DISTINCT PROJECTNUM, PROJECTNAME, ACT_NUM FROM PROJECT WHERE PROJECT = 'AD%' ORDER BY PROJNUM, ACT_NUM
SELECT E.EMPNUM, E.LASTNAME, A.PROJECTNUM FROM EMPLOYEE E, ACT_PROJ A WHERE A.PROJECTNUM = 'AD3113' AND A.EMPNUM = E.EMPNUM ORDER BY E.EMPNUM AND A.PROJNUM
貌似是这样 最好把 表名和字段名都给出来