Create table student1(roll int,name varchar(10),sub1 int,sub2 int,sub3 int)
insert into student1 values(1,'sonia',10,5,30)
insert into student1 values(2,'asha',5,20,8)
insert into student1 values(3,'Usha',10,5,3)
select * from student1
select roll from student1 where sub3 IN (select
min(sub3) from student1)
The above Query will retrieve the roll having the minimum marks in one subject, I do not know how to retrieve the roll having the min marks in two subjects....