4
0.21
Write command and queries to create and manipulate the records of a table named
'Students' with the following fields:
Roll No
Name
Class
Marks
101
Ajay
X
765
107
Suraj
IX
865
109
Simran
X
766
103
Aman
IX
821
104
Naresh
IX
1
a. Write SOL commands to create the above-given table. Set appropriate datatypes
for the fields.
b. Write a query to display the details of all the students studying in class X.
(c. Write the query to change the Roll No of the student named Aman to 106,
d Write a query to delete the record where the value of Marks is 1.
Answers
Answered by
1
Answer:
Pantoprazole is used to treat certain stomach and esophagus problems (such as acid reflux). It works by decreasing the amount of acid your stomach makes. This medication relieves symptoms such as heartburn, difficulty swallowing, and persistent cough
Similar questions
Social Sciences,
1 month ago
Math,
1 month ago
Math,
3 months ago
Science,
3 months ago
English,
10 months ago