Question

Write the SQL commands to answer the queries based on the student table Rollno Name Age Marks 101 Rohan 14 90 102 Shyam 15 40 103 Geeta 13 60 104 Sita 16 95 105 Anuj 14 98 (a) Write a query to display the record of those students whose age is more than 14 (b) To Modify the marks of students increasing by 10 (c) Write a query to delete the record of a students whose Rollno is 103​

Answer 1

Answer:

a) select * from student

where age>14 ;

b) update student

set marks=marks + 10;

c) delete from student

where rollno = 103;