Write SQL Queries for following Emp table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMET 1001 Juniad Juniad@abc.com 2010-06-18 110000.00 CS 1002 Irfan Irfan@abc.com 2011-04-16 100000.00 Sales 1003 Hassan Hassan@abc.com 2010-03-08 88000.00 Marketing 1004 Fahad Fahad@abc.com 2013-01-28 90000.00 Sales 1005 Husnain Hus@abc.com 2012-01-28 55000.00 ES 1. Write a query to display the names and email of all employees. 2. Write a query to display sales and marketing department data. 3. Write a query to get all employee details from the employee table order by first name, descending. 4. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 5. Write a query to get the total salaries payable to employees. 6. Write a query to get the maximum, minimum, sum, average salary and number of employees from emp table. 7. Write a query to find name whose name Start with ‘H’ and 'J'. 8. Write a query get all names from employees table in upper case. 9. Write a query to select first 2 records from a table. 10. Write a query to get the name of employees ends with character ‘N’. Such as Hassan etc. 11. List all employee and add 500 to their salaries, also change the column heading to Salary WithBonus. 12. Show all records whose salary is more than 55000.00 and less than 100000.00
Write SQL Queries for following Emp table :
EMPLOYEE_ID
Name EMAIL
HIRE_DATE
SALARY
DEPARTMET
1001 Juniad Juniad@abc.com 2010-06-18 110000.00 CS
1002 Irfan Irfan@abc.com 2011-04-16 100000.00 Sales
1003 Hassan Hassan@abc.com 2010-03-08 88000.00 Marketing
1004 Fahad Fahad@abc.com 2013-01-28 90000.00 Sales
1005 Husnain Hus@abc.com 2012-01-28 55000.00 ES
1. Write a query to display the names and email of all employees.
2. Write a query to display sales and marketing department data.
3. Write a query to get all employee details from the employee table order by first name, descending.
4. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary).
5. Write a query to get the total salaries payable to employees.
6. Write a query to get the maximum, minimum, sum, average salary and number of employees from emp table.
7. Write a query to find name whose name Start with ‘H’ and 'J'.
8. Write a query get all names from employees table in upper case.
9. Write a query to select first 2 records from a table.
10. Write a query to get the name of employees ends with character ‘N’. Such as Hassan etc.
11. List all employee and add 500 to their salaries, also change the column heading to Salary WithBonus.
12. Show all records whose salary is more than 55000.00 and less than 100000.00
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
