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

Explain relational data?

896

Why do we use stored procedures in sql server?

921

What is the difference between for auto and for nested?

981

How to make remote connection in database?

990

how can you attach more than 20 ldf files in sql server

1984

Tell me what is the difference between locking and multi-versioning?

1005

What is sql server profiler?

983

How to delete duplicate rows?

970

What are a database and a data warehouse?

1007

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1187

How to find the service pack installed? : sql server database administration

1009

What are the restrictions that views have to follow? : SQL Server Architecture

973

What is a collation?

1073

What do you know about normalization and de- normalization?

906

What is difference between view and materialized view?

925