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 sql or structured query language?
What are logical/boolean operations in ms sql server?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What are subqueries in sql server? Explain its properties.
What is store procedure? When do you use?
How to choose all records from the table?
What are the different types of collation sensitivity in sql server?
what is a transaction and what are acid properties? : Sql server database administration
How to update a field in SQL after ALTERING a row?
Find first and last day of current month in sql server
what is a self join? : Sql server database administration
What are pages and extents? : SQL Server Architecture
What are the different types of locks in the database?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
Explain the different index configurations a table can have?