Scribd
Upload
25 views10 pages

SQL Queries for Employee Data Management

The document outlines SQL programming tasks including creating a table named 'Empdata', inserting records, and displaying its structure. It provides specific SQL queries to filter employee data based on salary, location, designation, and bonus, as well as to sort employee names and increase bonuses. The document serves as a guide for performing various operations on the 'Empdata' table.

Uploaded by

11166
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
25 views10 pages

SQL Queries for Employee Data Management

The document outlines SQL programming tasks including creating a table named 'Empdata', inserting records, and displaying its structure. It provides specific SQL queries to filter employee data based on salary, location, designation, and bonus, as well as to sort employee names and increase bonuses. The document serves as a guide for performing various operations on the 'Empdata' table.

Uploaded by

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

SQL PROGRAMS

1. Create a table “Empdata” with the following structure :


2. Insert the following records in the table:
3. Display the structure of the table ‘Empdata’ :
[Link] the SQL queries for the following:
1. To display the details of all the employee whose salary is less than
15000
2. To display the name, designation ,date of joining and address of
employee who belong to Noida.
3. To display the details of all employees whose bonus is 120;
4. To display the details of employees who don’t belong to MUMBAI.
5. To display the details of employees whose designation is “clerk” and
lives in NOIDA
6. To display the name of employee with their salary +bonus display it as
“With extra bonus”
7. Write a query to arrange the employee names in ascending order.
[Link] display the details of all the employee
whose salary is less than 15000

[Link] display the name, designation ,date of joining


and address of employee who belong to Noida.
[Link] display the details of all employees whose bonus is 120;

4.4. To display the details of employees who don’t belong to MUMBAI.


4.5 To display the details of employees whose designation is “clerk” and lives
in NOIDA

4.6 .To display the name of employee with their salary added to their bonus display it as “With extra bonus”
4.7 Write a query to arrange the employee names in ascending
order.
[Link] the SQL queries for the following:
• To Increase the bonus of all employee in the empdata by 10%.

You might also like