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

Display a roll having miminum marks in two subjects?

Question Posted / jiten patel

Answer Posted / jiten patel

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is cte (common table expression)?

1033

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

What happens if null values are involved in datetime operations?

975

What are the components of sql server service broker?

1017

What is “asynchronous” communication in sql server service broker?

1034

How to delete an existing row with delete statements in ms sql server?

1093

What is data source in connection string?

910

How check triggers in sql server?

992

Why use sub query in sql server and list out types of sub queries?

1000

How to create an multi-statement table-valued function?

998

Can you explain various data region available in ssrs with their use?

976

What is service broker? : sql server database administration

995

What are the different authentication modes in sql server? How can it be changed?

1090

Will the writetext statement activate a trigger?

1095

Tell me when is the update_statistics command used?

1113