If a table named mark” has field’s regNo. sub code and marks write

If a table named mark” has field’s regNo. sub code and marks write SQL statements for the following:a) List the subject codes eliminating duplicates. (b) List the marks obtained by Students with subject codes 3001 and 3002. (c) Arrange the table based on marks for each source (d) List all the Students who have obtained marks above 90 for the subject codes 3001 and 3002. (e) List the contents of the table in the descending order of marks.

Answer»

(a) Select distinct sub code from mark;

(b) Select marks from mark where sub Code= 3001 or sub Code = 3002;

(d) Select * from mark where sub code in (3001,3002) and marks >90;

(e) Select *from mark order by marks desc;