SQL%20Lab%20Exercises-1 Table Creation Show Structure Record Insertion Update - 1 Update - 2 Select Query - 1 Select Query - 2 Select Query - 3 Select Query - 4 Select Query - 5 Select Query - 6 SELECT with SUM() SELECT with AVG() SELECT with DISTINCT SELECT with BETWEEN SELECT with GROUP BY


Update - 1

Q:4
Update DA in the table as 40% of BasicPay.


SQL> UPDATE EMPLOYEE SET DA=BASICPAY*0.40;

5 rows updated.