Scribd
Upload
26 views2 pages

Assignment 4: 1. Create Below Tables, EMP - E1

The document contains an assignment to create two database tables, EMP_E1 and EMP_E2, with sample data. It then provides four questions to write SQL queries on the tables: 1) to display all records, 2) to display unique records, 3) to select records for employees in the HR department, and 4) to select employees with a salary over 20K.

Uploaded by

Alankar dhakate
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
26 views2 pages

Assignment 4: 1. Create Below Tables, EMP - E1

The document contains an assignment to create two database tables, EMP_E1 and EMP_E2, with sample data. It then provides four questions to write SQL queries on the tables: 1) to display all records, 2) to display unique records, 3) to select records for employees in the HR department, and 4) to select employees with a salary over 20K.

Uploaded by

Alankar dhakate
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Assignment 4

1. Create below tables,

EMP_E1

ID Name Salary Dept


1 A 10000 IT
2 B 20000 IT
3 C 30000 HR
4 D 20000 HR
5 E 60000 HR
6 F 70000 FIN
7 G 40000 FIN
8 H 20000 ADM

EMP_E2

ID Name Salary Dept


101 x 90000 IT
102 y 30000 IT
103 z 32000 HR
104 p 11000 HR
105 q 10000 HR
6 f 70000 FIN
7 g 40000 FIN
8 h 20000 ADM

a. Write a query to display all the records from EMP_E1 and EMP_E2.

b. Write a query to display all records from EMP_E1 and EMP_E2 records
should be unique.
c. Write a query to select those employees who are working in HR
department from EMP_E1 and EMP_E2 table.

d. Write a query to select those employees who is having salary more then
20K. from both the tables.

You might also like