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


Please Help Members By Posting Answers For Below Questions

List down some advantages of sql stored procedure?

643


Define tool Manage Statistics in SQL Server 2000 query ?

609


Why do you want to join software field as you have done your BE in Electronics?

1791


What happens if the update subquery returns no rows in ms sql server?

694


Tell me what is the significance of null value and why should we avoid permitting null values?

620






what is a schema in sql server 2005? : Sql server database administration

605


What are sp_configure commands and set commands?

638


How can you control the amount of free space in your index pages?

693


What does normalization do to data?

636


How to connect Azure federated root database and apply federation in entity framework?

97


What does nvl stand for?

634


what is a join? : Sql server database administration

640


How to insert stored procedure result into temporary table?

672


Mention the differences between local and global temporary tables.

653


Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

601