Consultas Base De Datos

Consultas base de datos

--1
SELECT Eno, Sal, Comm, Deptno, Hiredate,
FROM Emp;
--2
SELECT *
FROM Dept;
--3
SELECT Ename
FROM Emp
WHERE job =`salesman´;
--4
SELECT Ename
FROM Emp
WHERE Deptno < >30;

--5
SELECT Ename
FROM Emp
WHERE Sal >2000;

--6
SELECT Ename
FROM EmpWHERE Hiredate < 1982-01-01;

--7
SELECT Ename
FROM Emp
WHERE Sal >1500;

--8
SELECT Ename
FROM Emp
WHERE Job =`Clerk´ OR Deptno = 30;

--9SELECT Eno, Ename, Job, Mgr, Hiredate, Sal, Comm, Deptno
FROM Emp
WHERE Ename = `Smith´ OR Ename = `Allen´ OR Ename = `scott´;

--10
SELECT Eno, Ename,Job, Mgr, Hiredate, Sal, Comm, Deptno
FROM Emp
WHERE Ename <> `Smith´or Ename <> `Allen´ or Ename <> `scott´;

--11
SELECT Ename
FROMEmp
WHERE Sal > 2000 AND Sal < 3000;

--12
SELECT Ename
FROM Emp
WHERE Deptno =(SELECT Deptno FROM Emp WHERE ename = `clark´);

--13
SELECTEname
FROM Emp
WHERE Deptno =(SELECT Deptno FROM Dept WHERE Loc = `Chicago´);

--14
SELECT em. Ename, em. Job, em.Depto, De .Loc
FROM Emp.em, DeptWHERE Em .Depto = de Deptng

--15
SELECT Ename
FROM Emp
WHERE Deptno = 10 OR Deptno = 20;

--16
SELECT Depno
FROM Emp
ORDER BY ASENDENT Depno
GROUP BYDepno;

--17
SELECT Depno, Job
FROM Emp
ORDER BY ASENDENT Depno
GROUP BY Job;

--18
SELECT Ename
FROM Emp
WHERE Hredate LIKE `%1981´;

--19
SELECTEname
FROM Emp
WHERE Comm <> Null;

--20
SELECT Ename
FROM Emp
WHERE Ename LIKE `A%´;

--21
SELECT Ename
FROM Emp
WHERE Ename LIKE`_ D%´;