English

Insert the following information: Students Adno Name Average Sex Scode 501 R.Jain 98 M 111 545 Kavita 73 F 333 705 K.Rashika 85 F 111 754 Rahul Goel 60 M 444 892 Sahil Jain 78 M 333 935 Rohan Saini

Advertisements
Advertisements

Question

Insert the following information:

Students

Adno Name Average Sex Scode
501 R.Jain 98 M 111
545 Kavita 73 F 333
705 K.Rashika 85 F 111
754 Rahul Goel 60 M 444
892 Sahil Jain 78 M 333
935 Rohan Saini 85 M 222
955 Anjali 64 F 444
983 Sneha Aggarwal 80 F 222
Code Writing
Advertisements

Solution

INSERT INTO Students (Adno, Name, Average, Sex, Scode) VALUES
(501, 'R.Jain', 98, 'M', 111),
(545, 'Kavita', 73, 'F', 333),
(705, 'K.Rashika', 85, 'F', 111),
(754, 'Rahul Goel', 60, 'M', 444),
(892, 'Sahil Jain', 78, 'M', 333),
(935, 'Rohan Saini', 85, 'M', 222),
(955, 'Anjali', 64, 'F', 444),
(983, 'Sneha Aggarwal', 80, 'F', 222);
shaalaa.com
  Is there an error in this question or solution?
Chapter 10: Structure Query Language - EXERCISE [Page 200]

APPEARS IN

CBSE Computer Science with Python [English] Class 12
Chapter 10 Structure Query Language
EXERCISE | Q 27. | Page 200
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×