Oracle Queries
- Queries By Mr. Faruqh, Answers By Giridhar Ks
67, 88, 92, 95, 96, 102, 108, 117, 118, 119, 122, 125, 127, 131, 133, 134, 135, 137, 138, 139, 146, 149,
151, 155, 165, 168, 176, 188, 204, 208
ORACLE QUERIES NOT ANSWERED :
108, 118, 119, 122, 127, 131, 133, 134, 135, 137, 138, 146, 149, 151, 155, 176, 188, 204, 208
Queries 2 be checked 4 syntax : 165, 168.
001.
Display all the information of the emp table.
SQL>
Select * from emp ;
002.
Display unique jobs from EMP table.
SQL>
SELECT DISTINCT Job FROM EMP GROUP BY Job ;
003.
List the details of the emps in asc order of their salaries.
SQL>
SELECT * FROM EMP
ORDER BY Sal ASC ;
004.
List the details of the emps in asc order of the Deptnos and desc of Jobs.
SQL>
SELECT * FROM EMP
ORDER BY Deptno ASC, Job DESC ;
005.
Display all the unique job groups in the descending order
SQL>
select unique job from emp order by job desc ;
006.
Display all the details of all ‘Mgrs’
SQL>
select * from emp where job = 'MANAGER' ;
007.
List the emps who joined before 1981.
SQL>
select * from emp where hiredate < '01-Jan-1981' ;
008.
List the Empno, Ename, Sal, Daily Sal of all Employees in the ASC order of AnnSal.
SQL>
SELECT Empno, Ename, sal, Sal/30 DailySal
FROM Emp ORDER BY Sal*12 ;
009.
Display the empno , ename, job, hiredate, exp of all Mgrs
SQL>
select empno, ename, sal,
months_between(sysdate,hiredate)/12 Exp
from emp where job = 'MANAGER' ;
010.
List the empno, ename, sal, exp of all emps working for Mgr 7839.
SQL>
select empno, ename, sal,
months_between(sysdate,hiredate)/12 Exp
from emp B where Mgr = 7839 ;
011.
Display the details of the emps whose Comm. Is more than their sal.
SQL>
select * from emp where comm > sal ;
012.
List the emps in the asc order of Designations
