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

How to skip remaining statements in a loop block using continue statements?

928

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1077

How to count rows with the count(*) function in ms sql server?

950

What are the types of lock supported by ?

995

What is bit data type? What's the information that can be stored inside a bit column?

873

When to use null data driven subscription?

196

Is sql server is free?

920

How can you know if the row fetched from cursor is still valid in underlying table?

950

Why is replication required on the sql server?

1005

Characterize join and name diverse sorts of joins?

904

how many layers of tcp/ip protocol combined of? : Sql server database administration

934

What is ms sql server service broker?

929

what is a join? : Sql server database administration

1121

What is snapshot report?

151

What are sql azure firewall rules?

106