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

Tell me what do we need queues in sql service broker?

612

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

688

what is denormalization? : Sql server database administration

570

What is difference between inner join and join?

605

Explain the concept of recursive stored procedure.

582

Explain can SSRS reports Cache results?

118

Explain how many normalization forms?

658

What is recompile sql server?

659

How to Insert multiple rows with a single insert statement?

637

What is oltp (online transaction processing)?

670

Can the query output be sorted by multiple columns in ms sql server?

645

Explain features and concepts of analysis services?

578

What are the disadvantages of primary key and foreign key in SQL?

719

Explain difference between control flow and data flow?

626

What are views used for?

698