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 to manipulate data from one table to another table ?

0 Answers   MCN Solutions,

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

Can we insert data into a view?

0 Answers  

Can I delete event logs?

0 Answers  

List few advantages of stored procedure.

0 Answers  

What is a primary index?

0 Answers  

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

What is correlated subquery in sql server?

0 Answers  

Wht is SQL Injection Attack ?

3 Answers  

What is the difference between clustered index and primary key?

0 Answers