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
List down some advantages of sql stored procedure?
Define tool Manage Statistics in SQL Server 2000 query ?
Why do you want to join software field as you have done your BE in Electronics?
What happens if the update subquery returns no rows in ms sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?
what is a schema in sql server 2005? : Sql server database administration
What are sp_configure commands and set commands?
How can you control the amount of free space in your index pages?
What does normalization do to data?
How to connect Azure federated root database and apply federation in entity framework?
What does nvl stand for?
what is a join? : Sql server database administration
How to insert stored procedure result into temporary table?
Mention the differences between local and global temporary tables.
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?