Question

3.
Consider the following table :
Table : Student
AdmNo
StName
Class
Marks
100
Aayush
XI
90
101
Divyanshu
XII
85
102
Priyansh
XII
92
103
Aakash
XI
87
104
Saksham
XI
96
Write SQL query for the following:
Display name and marks of all students.
(ii) Display the name of all students who scored more than 90 marks.
(iii) To add a new row with the following data : “105”, “Kumar”, “XII”, 90.
(iv) Display detail of all students with student name start with.​

Answer 1

Answer:

Ttgigtsnierug dusre Vue uvfubrsgjh