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

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

1010

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1087

What are orphan records?

985

What is resource governor in sql server?

1048

How do I perform an unattended install of sql server 2000?

1136

What is a join in sql? What are the types of joins?

1188

Which is faster statement or preparedstatement?

1001

what is datawarehouse?

1154

What are the different types of cursor?

1148

What is the use of custom fields in report?

1041

What is report rendering ?

162

What is database replication?

1207

What is the use of floor function in sql server?

1126

What is an index in sql?

1066

How to create new tables with "select ... Into" statements in ms sql server?

1046