Select roll from student where mark1=(select min(mark1) from student) an

Display a roll having miminum marks in two subjects?

Question Posted / mahesh

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

Please Help Members By Posting Answers For Below Questions

What is sql or structured query language?

1088

What are logical/boolean operations in ms sql server?

982

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1019

What are subqueries in sql server? Explain its properties.

967

What is store procedure? When do you use?

873

How to choose all records from the table?

999

What are the different types of collation sensitivity in sql server?

1037

what is a transaction and what are acid properties? : Sql server database administration

966

How to update a field in SQL after ALTERING a row?

1182

Find first and last day of current month in sql server

978

what is a self join? : Sql server database administration

963

What are pages and extents? : SQL Server Architecture

959

What are the different types of locks in the database?

874

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1029

Explain the different index configurations a table can have?

887