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

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

134

How to create a view with data from multiple tables?

767

How to find the version of sql server? : sql server database administration

809

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

129

What is log shipping?

727

What is GUID in sql server?

821

How to delete existing triggers using "drop trigger"?

764

How to defragment indexes with alter index ... Reorganize?

769

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

794

What is ms sql server index?

743

How do I setup a local sql server database?

700

What are character string data types in ms sql server?

796

State a few properties of relational databases?

835

Is sql server free?

670

How to write a query with an inner join in ms sql server?

751