Display roll having lowest marks in minimum 2 subjects?
-
-
Kindly post what you have tried so far to solve this. -
Create table student1(roll int,name varchar(10),sub 1 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....Comment
Comment