Scribd
Upload
6 views2 pages

Query

The document provides SQL queries for managing an EMPLOYEE table with various attributes. It includes commands for inserting, displaying, updating, and deleting employee records based on specific criteria. Additionally, it outlines queries for filtering employees by job titles, salary comparisons, joining dates, and department numbers.

Uploaded by

sivakami
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
6 views2 pages

Query

The document provides SQL queries for managing an EMPLOYEE table with various attributes. It includes commands for inserting, displaying, updating, and deleting employee records based on specific criteria. Additionally, it outlines queries for filtering employees by job titles, salary comparisons, joining dates, and department numbers.

Uploaded by

sivakami
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

Create a table EMPLOYEE with following schema: (Emp_no, E_name,

E_address, E_ph_no, Dept_no, Dept_name,Job_id , Salary)

Write SQL queries for following question: 1. Insert aleast 5 rows in the table.

2. Display all the information of EMP table.

3. Display the record of each employee who works in department D10.

4. Update the city of Emp_no-12 with current city as Nagpur.

5. Display the details of Employee who works in department MECH.

6. Delete the email_id of employee James.

7. Display the complete record of employees working in SALES Department

Create a table EMPLOYEE with following schema: (Emp_no, E_name,

E_address, E_ph_no, Dept_no, Dept_name,Job_id, Designation , Salary)

Write SQL statements for the following query.

1. List the E_no, E_name, Salary of all employees working for MANAGER.

2. Display all the details of the employee whose salary is more than the Sal of

any IT PROFF..
3. List the employees in the ascending order of Designations of those joined

after 1981.

4. List the employees along with their Experience and Daily Salary.

5. List the employees who are either ‘CLERK’ or ‘ANALYST’ .

6. List the employees who joined on 1-MAY-81, 3-DEC-81, 17-DEC-81,19-

JAN-80 .

7. List the employees who are working for the Deptno 10 or20.

8. List the Enames those are starting with ‘S’ .

9. Dislay the name as well as the first five characters of name(s) starting with

‘H’

10. List all the emps except ‘PRESIDENT’ & ‘MGR” in asc order of Salaries.

You might also like