Display a roll having miminum marks in two subjects?
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 |
Post New Answer View All Answers
What is the use of RDBMS?
Explain for xml explicit mode?
When would you use the stored procedures or functions?
Will the writetext statement activate a trigger?
What are relationships and mention different types of relationships in the dbms
What are the new features of sql server 2008 r2 reporting service?
Tell me what is difference between clustered and non clustered index?
Explain ms sql server reporting services vs crystal reports?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Does group by or order by come first?
Explain the difference between functions and stored procedures in sql server?
What is the server name for sql management studio?
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?
Explain the disadvantages of cursors?
What are the different types of cursor?