Advertisements
Advertisements
Question
Write SQL statements to insert the remaining 4 rows of the STUDENT table.
| RollNumber | SName | SDateofBirth | GUID |
|---|---|---|---|
| 1 | Atharv Ahja | 2003-05-15 | 4444444444 |
| 2 | Daizy Bhutia | 2002-02-28 | 1111111111 |
| 3 | Taleem Shah | 2002-02-28 | |
| 4 | John Dzouza | 2003-08-18 | 3333333333 |
| 5 | Ali Shah | 2003-07-05 | 1010101010 |
| 6 | Manika P. | 2002-03-10 | 4664444466 |
Code Writing
Advertisements
Solution
INSERT INTO STUDENT VALUES (3, 'Taleem Shah', '2002-02-28', NULL);
INSERT INTO STUDENT VALUES (4, 'John Dzouza', '2003-08-18', 3333333333);
INSERT INTO STUDENT VALUES (5, 'Ali Shah', '2003-07-05', 1010101010);
INSERT INTO STUDENT VALUES (6, 'Manika P.', '2002-03-10', 4664444466);shaalaa.com
Is there an error in this question or solution?
