Display a roll having miminum marks in two subjects?

Answer Posted / jiten patel

Select * from Student_Info where Math=(select min(Math)from
Student_Info) and Eng=(select min(Eng) from Student_Info)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sub reports and how to create them?

103


What is the difference between dropping a database and taking a database offline?

798


What are different types of subquery?

820


Define master database?

663


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

663






Tell about MOM Tool(Microsoft Operator Manager)?

1501


How you can change a cross join into an inner join?

625


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

684


role of sql sever 2005 in database rather than any other database

1603


What are different types of statement?

602


Is the primary key column of a table an index in ms sql server?

625


what is unique and xaml nonclustered index

666


How to define output parameters in stored procedures?

631


What is Replication?

725


How do I schedule a sql server profiler trace?

623