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

When would you use sql joins?

939

How do I find the sql server database version?

988

Is a primary key unique?

981

What are types of scd? : sql server analysis services, ssas

1000

What are the new security features added in sql server 2012? : sql server security

1003

What is the difference between dropping a database and taking a database offline?

1154

How to optimize stored procedure optimization?

881

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1372

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1016

What are the different types of stored procedures?

1101

What is blocking?

1043

Does view occupy space?

925

What is an index in sql?

988

How to get the definition of a user defined function back?

1031

How to view the error log for any specific instance? : sql server database administration

1021