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'.
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
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
Plz give me all ans
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
