Select * from (table name)where (field1)=(select min(field1)from table n

Display a roll having miminum marks in two subjects?

Question Posted / jiten patel

Answer Posted / jiten patel

Select * from (table name)where (field1)=(select
min(field1)from
table name) and (field2)=(select min(field2) from table name)

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

Why do we use non clustered index?

1083

Why should one not prefix user stored procedures with ‘sp_’?

1046

What is an execution plan? How would you view the execution plan?

1077

Can we call stored procedure in view in sql server?

898

What is a virtual table in sql?

996

How to find the login name linked to a given user name?

1011

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

909

What is table level trigger?

1020

What should be the fill factor for indexes created on tables? : sql server database administration

1138

How to turn on the mssql api module in php?

1078

What is the difference between web edition and business edition?

111

What are the different types of indexes?

1118

How many categories of data types used by sql server?

1020

What is an indice?

1037