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

Do you know what are the differences between lost updates and uncommitted dependencies?

1136

When I run the sql server 2000 setup, it just hangs. What do I do?

1126

What is a partitioned view?

1051

Distinguish between nested subquery and correlated subquery?

1112

What are secondary xml indexes?

1074

Explain Normalization and DE normalization

1158

Does the unique constraint create an index?

1133

How connect excel to sql server?

1051

What are extended events in sql server?

1005

What is view in sql?

949

List the data types available in mssql?

1101

What is a View ? Can we insert, Update and delete a view?

1059

What is sql server agent and what are the two modes of authentication in sql server?

1108

How important do you consider cursors or while loops for a transactional database?

1010

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

1041