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

Q.No.1. Write the SQL queries.<br>Employee:<br>Address<br>Emp_name<br>Ali<br>Deptno<br>Empno<br>Salary<br>D1<br>Rawalpindi<br>DIE1<br>5,000<br>10,000<br>D1<br>Islamabad<br>DZEZ<br>Alia<br>D2<br>Lahore<br>DBE3<br>Usman<br>25,000<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.<br>As we can see department no. 1 is repeated in the table, display the unique department<br>num ber,<br>Answer:<br>5. Display the employee name who are living in Lahore.<br>Answer:<br>

Extracted text: Q.No.1. Write the SQL queries. Employee: Address Emp_name Ali Deptno Empno Salary D1 Rawalpindi DIE1 5,000 10,000 D1 Islamabad DZEZ Alia D2 Lahore DBE3 Usman 25,000 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 num ber, Answer: 5. Display the employee name who are living in Lahore. Answer:

Jun 05, 2022

SOLUTION.PDF

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

Get Answer To This Question

Related Questions & Answers

Submit New Assignment