Select * from Student_Info where Math=(select min(Math)from Student

Display a roll having miminum marks in two subjects?

Question Posted / rajesh

Answer Posted / rajesh

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

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to convert binary strings into integers in ms sql server?

1027

Differentiate between sql temp table vs table variable?

879

your distribution database is full what will u do

2172

What are key constraints?

972

what are the different types of replication you can set up in sql server? : Sql server database administration

1023

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1036

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

958

What are various ways to enhance the ssrs report?

981

Define the one-to-one relationship while designing tables.

903

What the different topologies in which replication can be configured?

1087

What are the difference between clustered and a non-clustered index?

1043

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1161

What is data source view or dsv? : sql server analysis services, ssas

1000

How is a full-text index updated?

954

What are the dmvs? : sql server database administration

1058