Question

to display Rno, Name, DOB of those students who are born between'2005-01-01' and '2005-12-31​

Answer 1

Answer:

Explanation:

(1) update table_name set marks = marks + 10;

(2) select name , marks from table_name where section = 'A' ;

(3) select * from table_name where name = 'ANAND' ;

(4) select id , name , dob from table_name where dob > '2005-01-01' and dob < '2005-12-31' ;

(5) select id , name , dob , marks from table_name where gender = 'male' ;

(6) select id , gender , name , dob , marks from table_name where section = 'B' and marks > 50 ;

(7) select * from table_name where class = 'xi' and section = 'C' or section = 'D' ;

(8) select * from table_name where section != 'E' ;

(9) select name , gender from table_name where id > 300 and id < 400 ;