Question

35. Write SQL queries for the question from (i) and (v) on the basis of table class.

Roll No Name SUBJECT MARKS GRADE

1 Neha Medical 450 A

2 Karan Medical 470 A+

3 Kanak Humanities 390 B

4 Esha Non-Medical 415 B+

5 Rahul Humanities 380 B

(i) To insert the following record(6,’Arif’,’Medical’,490,’A+’

(ii) To display only those students’ details whose Grade is A+.

(iii) To delete the record of RollNo 3 from table.​

Answer 1

Answer:

(i). INSERT INTO TABLE ,'(ROLL NO, . NAME , SUBJECTS , MARKS GUIDE) VALUES ( 6,'Arif,'Medical,'490,'A+)

(ii). SELECT * From table 'where' Grade = A+

(iii). DELETE From table 'where' Roll No. = 3

hope it helps dear..

mark as brainliest.

“ψ(｀∇´)ψ

(Rohit)