cl1p.net - The internet clipboard

cl1p.net/xxxx

This cl1p will be deleted in in 23 days.

CREATE TABLE Employee(E_ID INT,E_NAME VARCHAR(50),E_ADDRESS VARCHAR(50),E_SALARY INT, D_NO VARCHAR(10));
INSERT ALL 
INTO Employee VALUES(1,'Mr Qayser Mohi-ud-din','Budgam',20000,'D1')
INTO Employee VALUES(2,'Nadeem Shahmir','Ganderbal',20000,'D2')
INTO Employee VALUES(3,'Mr Mohammad ilyas Malik','Kupara',28000,'D3')
INTO Employee VALUES(4,'Ms Bisma Rashid','Srinagar',30000,'D4')
INTO Employee VALUES(5,'Mr Rashid Wani','Pulwama',28000,'D5')
INTO Employee VALUES(6,'Mr Manzoor Ahmad','Ganderbal',40000,'D6')
INTO Employee VALUES(7,'Mr Sameer ahmad','Sumbal',25000,'D7')
INTO Employee VALUES(8,'Mr Mushtaq Ahmad','Ganderbal',NULL,'D8')
SELECT * FROM DUAL;

SELECT * FROM Employee;
CREATE TABLE Department(D_NO VARCHAR(10),D_NAME VARCHAR(30),D_LOCATION VARCHAR(50));
INSERT ALL 
INTO Department VALUES('D1','HR','Kupara')
INTO Department VALUES ('D2', 'IT', 'Srinagar')
INTO Department VALUES ('D3', 'Finance', 'Ganderbal')
INTO Department VALUES ('D4', 'Management', 'Pulwama')
INTO Department VALUES ('D5', 'Health', 'Srinagar')
SELECT * FROM DUAL;

SELECT * FROM Department;

SELECT * FROM Employee WHERE E_ADDRESS IN('Kupara','Srinagar','Budgum');
SELECT * FROM Employee WHERE E_ADDRESS NOT IN('Kupara','Srinagar','BUDGAM');

SELECT E_NAME FROM Employee WHERE D_NO IN(SELECT D_NO FROM Department);
SELECT E_NAME FROM Employee WHERE D_NO NOT IN(SELECT D_NO FROM Department);

SELECT E_NAME FROM Employee WHERE D_NO IN(SELECT D_NO FROM Department WHERE D_NAME='FINANCE');

SELECT * FROM Employee
WHERE E_ADDRESS = (
    SELECT D_LOCATION FROM Department
    WHERE Department.D_NO = Employee.D_NO
);

SELECT * FROM Employee
WHERE dept_no > ALL ('D1', 'D2', 'D3');

SELECT * FROM Employee
WHERE dept_no > (
    SELECT dept_no FROM Department
    WHERE dept_name = 'IT'
);

SELECT * FROM Employee
WHERE dept_no > ANY ('D4', 'D5');

SELECT * FROM Employee
WHERE dept_no > ANY (
    SELECT dept_no FROM Department
);