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

What are the differences between stored procedure and view in sql server?

1219

Can you name a few encryption mechanisms in sql server?

927

Can primary key be null?

916

Is sql different from sql server?

1058

What have included columns when we talk about sql server indexing?

1016

Do you know what is sql service broker?

1054

How to see existing views in ms sql server?

1021

What is normalization? What number of normalization shapes are there?

1090

What do you mean by an execution plan? Why is it used?

994

What happens when converting big values to numeric data types?

1100

Explain what is meant by replication of database?

1018

How do I make a resultset scrollable?

940

Explain what is the difference between union and union all?

990

What are views in ms sql server?

1058

What is the difference between for trigger and after trigger?

1085