Answer / sonia

create table student7(Roll int,English int,Hindi int,Maths
int)
insert into student7 values(1,12,15,9)
insert into student7 values(2,23,3,13)
insert into student7 values(3,15,12,4)

select roll from student7 where
maths=(select min(maths) from student7)
AND
English=(select min(english)from student7)

Rajesh, AND Operator is used b/w two conditions . Answer
given by you is limted to two subjects, if there are three
or more subjects then

Answer / pradip jain

Select * from marks where
(Math=(select min(Math)from
marks) and phy=(select min(phy) from marks))
OR
(Math=(select min(Math)from
marks) and chem=(select min(chem) from marks))
OR
(Phy=(select min(phy)from
marks) and chem=(select min(chem) from marks))


Sonia if it is 3 subject and will be combine with or clause

Answer / mahesh

Select roll from student
where mark1=(select min(mark1) from student)
and mark2=(select min(mark2) from student)

Answer / ivee

Suppose we are having a table called abc which has field
name as marks, subject and roll
now roll2 and roll3 has the same minimum marks as 40
so the query will be

select roll from abc where marks=(select min(marks) from
abc)

Answer / rajesh

Select * from Student_Info where Math=(select min(Math)from
Student_Info) or Eng=(select min(Eng) from Student_Info)

Answer / jiten patel

Select * from Student_Info where Math=(select min(Math)from
Student_Info) and Eng=(select min(Eng) from Student_Info)

Answer / jiten patel

Select * from (table name)where (field1)=(select
min(field1)from
table name) and (field2)=(select min(field2) from table name)

How do you load large data to the SQL server database?

2 Answers  

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 Answers  

What is transaction server auto commit?

0 Answers  

What do you mean by a Composite primary key?

0 Answers   Genpact,

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

how to generate XML out of QUERY?

1 Answers   McAfee,

How can you get @@error and @@rowcount at the same time?

9 Answers  

How do clustered indexes store data?

0 Answers  

What is named calculation? : sql server analysis services, ssas

0 Answers  

what is Full Text Search ?

1 Answers   TCS,

How to make a column nullable?

0 Answers  

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,