English

Write SQL statements to insert the remaining 3 rows of table in table GUARDIAN.444444444444, 111111111111, 101010101010, 333333333333, 466444446666

Advertisements
Advertisements

Question

Write SQL statements to insert the remaining 3 rows of table in table GUARDIAN.

GUID GName GPhone

GAddress

444444444444 Amit Ahuja 5711492685 G-35, Ashok Vihar, Delhi
111111111111 Baichung Bhutia 3612967082 Flat no. 5, Darjeeling Appt., Shimla
101010101010 Himanshu Shah 4726309212 26/77, West Patel Nagar, Ahmedabad
333333333333 Danny Ds ouza   S-13, Ashok Village, Daman
466444446666 Sujata P. 3801923168 HNO-13, B-block, Preet Vihar, Madurai
Code Writing
Advertisements

Solution

INSERT INTO GUARDIAN
VALUES
(101010101010, 'Himanshu Shah', 4726309212, '26/77, West Patel Nagar, Ahmedabad');
INSERT INTO GUARDIAN
VALUES
(333333333333, 'Danny Ds ouza', NULL, 'S-13, Ashok Village, Daman');
INSERT INTO GUARDIAN
VALUES
(466444446666, 'Sujata P.', 3801923168, 'HNO-13, B-block, Preet Vihar, Madurai');
shaalaa.com
  Is there an error in this question or solution?
Chapter 8: Introduction to Structured Query Language (SQL) - Intext Questions [Page 154]

APPEARS IN

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

Englishहिंदीमराठी


      Forgot password?
Use app×