wapbold.net

Enter Value For Address PALANI Enter Value For Salary 6000 Old 1 Insert Into Customers Valuesidnameageaddresssalary New 1 Insert Into Customers Values106DEVAKUMAR44PALANI6000 1 Row Created SQL SQL SELECT FROM CUSTOMERS ID NAME AGE ADDRESS SALARY 101 Raja 55 Chennai 4000 102 Manikandan 44 Salem 5000 103 Gobi 66 Trichy 10000 104 Kannan 55 Chennai 4000 105 BALA 44 TRICHY 5000 106 DEVAKUMAR 44 PALANI 6000 6 Rows Selected 1 Subqueries With The SELECT Statement SQL SELECT FROM CUSTOMERS WHERE ID INSELECT ID FROM CUSTOMERS WHERE SALARY 4500 ID NAME AGE ADDRESS SALARY 102 Manikandan 44 Salem 5000 103 Gobi 66 Trichy 10000 105 BALA 44 TRICHY 5000 106 DEVAKUMAR 44 PALANI 6000 SQL 2 Subqueries With The INSERT Statement SQL Create Table Customersbkpid Number4name Varchar15age Number3addr Ess Varchar15salary Number72 Table Created SQL Insert Into Customersbkp Select From Customers Id Fro M Customers

Recent Searches

Go UP