Insert all those records of table Accounts into table Pending where amt_outstanding is more than 10000.
11 Likes
INSERT INTO Pending SELECT * FROM Accounts WHERE amt_outstanding > 10000;
Answered By
6 Likes
Differentiate between DROP TABLE, DROP DATABASE.
Differentiate between DROP TABLE, DROP clause of ALTER TABLE.
Increase salary of employee records by 10% (table employee).
Give commission of Rs.500 to all employees who joined in year 1982 (table Empl).