David Carothers Capitol College CS-220 Database Management Final Exam 1. SELECT ENAME, HIREDATE FROM EMP WHERE DEPTNO = (SELECT DEPTNO FROM EMP WHERE ENAME = 'BLAKE') AND ENAME != 'BLAKE' 2. SELECT EMPNO, ENAME FROM EMP WHERE SAL > (SELECT AVG(SAL) FROM E
David Carothers CS-220 11/5/07 Assignment #8 SQL Assignment #4 1. select emp.ename, emp.deptno, dept.deptno from emp, dept 2. select job from emp where deptno LIKE 30 3. Select e.ename , d.dname, d.loc from emp e, dept d where e.deptno = d.deptno and e.co
David Carothers CS-220 10/29/07 Assignment #7 SQL assignment #3 (Microsoft Word made a lot of the columns crooked) 1. input: select sysdate as "Date" from dual; Date -22-OCT-07 2. input: select empno, ename, sal, round(sal*1.15,0) as "New Salary" from emp
Capitol College CS220 - Database Management Assignment # 8 SQL Assignment # 4 1.Write a query to display the name, department number, and department name for all employees. Select e.ename, e.deptno, d.dname from emp e, dept d Where e.deptno = d.deptno; 2.
Capitol College CS220 - Database Management Assignment # 6 SQL Assignment # 2
1. Create a query to display the name and salary of employees earning more than $2850. Save your SQL statement to a file named p2ql.sql. Run your query. SQL> SELECT ename,sal 2
Capitol College CS220 - Database Management Assignment # 7 SQL Assignment # 3 1. Write a query to display the current date. Label the column Date. SQL> select sysdate "Date" from dual; 2. Display the employee number, name, salary, and salary increase by 1