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

What security features are available for stored procedure?

1004

What is logshipping and its purpose?

959

How to replace given values with null using nullif()?

946

on line cluster can we make if yes tell me the procedure

1992

What are the character string functions supported by sql server 2005?

954

How to name query output columns in ms sql server?

930

What is conditional split?

1022

Different types of keys in SQL?

1066

What are the new scripting capabilities of ssms? : sql server management studio

1018

Which sql server table is used to hold the stored procedure script?

898

How retrieve field names from the table in SQL through JAVA code?

1854

What is the syntax to execute the sys.dm_db_missing_index_details?

987

What is code near application topology?

275

What have included columns when we talk about sql server indexing?

1005

What are the main differences between #temp tables and @table variables and which one is preferred?

1034