Q.No.1. Write the SQL queries. (10) Employee: Deptno Address Empno Emp_name Salary Rawalpindi Ali 5,000 10,000 25,000 D1 DIE1 D1 Islamabad D2E2 Alia D2 Lahore D3E3 Usman 1. Display detail of all...

Q.No.1. Write the SQL queries.<br>(10)<br>Employee:<br>Deptno<br>Address<br>Empno<br>Emp_name<br>Salary<br>Rawalpindi<br>Ali<br>5,000<br>10,000<br>25,000<br>D1<br>DIE1<br>D1<br>Islamabad<br>D2E2<br>Alia<br>D2<br>Lahore<br>D3E3<br>Usman<br>1. Display detail of all employees from Employee table.<br>Answer:<br>2. Display name of employees, who are working in D1.<br>Answer:<br>3. Add bonus of 500 to all employee's salary.<br>Answer:<br>4. As we can see department no. 1 is repeated in the table, display the unique department<br>number.<br>Answer:<br>

Extracted text: Q.No.1. Write the SQL queries. (10) Employee: Deptno Address Empno Emp_name Salary Rawalpindi Ali 5,000 10,000 25,000 D1 DIE1 D1 Islamabad D2E2 Alia D2 Lahore D3E3 Usman 1. Display detail of all employees from Employee table. Answer: 2. Display name of employees, who are working in D1. Answer: 3. Add bonus of 500 to all employee's salary. Answer: 4. As we can see department no. 1 is repeated in the table, display the unique department number. Answer:

5. Display the employee name who are living in Lahore.<br>Answer:,<br>

Extracted text: 5. Display the employee name who are living in Lahore. Answer:,

Jun 05, 2022

SOLUTION.PDF

Q.No.1. Write the SQL queries. (10) Employee: Deptno Address Empno Emp_name Salary Rawalpindi Ali 5,000 10,000 25,000 D1 DIE1 D1 Islamabad D2E2 Alia D2 Lahore D3E3 Usman 1. Display detail of all...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment