English

Write SQL statements to insert the remaining 4 rows of the STUDENT table. RollNumber 1 2 3 4 5 6 SName Atharv Ahja, Daizy Bhutia, Taleem Shah, John Dzouza, Ali Shah, Manika P.

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?
Chapter 8: Introduction to Structured Query Language (SQL) - Intext Questions [Page 156]

APPEARS IN

NCERT Informatics Practices [English] Class 11
Chapter 8 Introduction to Structured Query Language (SQL)
Intext Questions | Q 12 | Page 156
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×