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 the use of RDBMS?

1055

Explain for xml explicit mode?

1024

When would you use the stored procedures or functions?

1050

Will the writetext statement activate a trigger?

1152

What are relationships and mention different types of relationships in the dbms

1011

What are the new features of sql server 2008 r2 reporting service?

212

Tell me what is difference between clustered and non clustered index?

981

Explain ms sql server reporting services vs crystal reports?

973

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1106

Does group by or order by come first?

996

Explain the difference between functions and stored procedures in sql server?

1018

What is the server name for sql management studio?

1096

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1011

Explain the disadvantages of cursors?

1205

What are the different types of cursor?

1148