Write the SQL queries. (10) Employee: Deptno Address Empno Emp_name Salary D1 Rawalpindi D1E1 Ali 5,000 D1 Islamabad D2E2 Alia 10,000 D2 Lahore D3E3 Usman 25,000
Write the SQL queries. (10)
Employee:
|
Deptno |
Address |
Empno |
Emp_name |
Salary |
|
D1 |
Rawalpindi |
D1E1 |
Ali |
5,000 |
|
D1 |
Islamabad |
D2E2 |
Alia |
10,000 |
|
D2 |
Lahore |
D3E3 |
Usman |
25,000 |
- Display detail of all employees from Employee table.
Answer:
- Display name of employees, who are working in D1.
Answer:
- Add bonus of 500 to all employee’s salary.
Answer:
- As we can see department no. 1 is repeated in the table, display the unique department number.
Answer:
- Display the employee name who are living in Lahore.
Step by step
Solved in 2 steps
