Select roll from student where mark1=(select min(mark1) from student) an

Display a roll having miminum marks in two subjects?

Question Posted / mahesh

Answer Posted / mahesh

Select roll from student
where mark1=(select min(mark1) from student)
and mark2=(select min(mark2) from student)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is coalesce and check constraint in sql server?

1122

What are the restrictions while creating batches in sql server?

1062

What is raid, and how it can influence database performance?

1058

difference between Clustered index and non clustered index ?

993

Can two tables have the same primary key?

1209

What is transaction server consistency?

1046

What is encryption key?

130

what are isolation levels? : Sql server database administration

995

Where the sql logs gets stored?

987

What is a data source file?

975

what's the difference between delete table and truncate table commands? : Sql server database administration

983

What is the current pricing model of SQL Azure?

104

When would you use sql joins?

962

List the different index configurations possible for a table?

934

How to create a stored procedure with a statement block in ms sql server?

1070