关于DB2的一些问题
问题一
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 project number,project name,and activity number.List identical rows once.Order the list by project number and then by activity number.
第六题
Which employees are assigned to project number AD3113?List employee number,last name,and project number.Order the list by employee number and then by project number.List only one occurrence of duplicate result rows.
实在是麻烦啦~谢谢啦~
答案: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
貌似是这样 最好把 表名和字段名都给出来
其他:SELECT LASTNAME,DEPTNUMBER
FROM ADMINISTRATOR.EMPLOYEE
ORDER BY LASTNAME DESC,DEPTNUMBER;
上一个:关于db2创建表的问题,谢谢各位大侠了!!
下一个:DB2中group by 后 如何获得字符累加聚合的效果