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)

What are views used for?

0 Answers  

Define cursor locking

0 Answers  

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,

What does the automatic recovery do?

1 Answers  

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

Why use stored procedures in sql server?

0 Answers