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

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

965

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1081

tell me the disaster recovery plan

2500

Can I save my report as html, excel or word? : sql server management studio

932

What is the benefit of normalization?

1061

Why normalization is used?

993

Write an sql query for deleting duplicate rows?

982

What is the new security features added in sql server 2014? : sql server security

985

What do you understand by a view? What does the with check option clause for a view do?

986

explain different types of cursors? : Sql server database administration

1068

What are binary string data types in ms sql server?

1254

What is replication and database mirroring?

1028

Explain the properties of the relational tables?

979

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1058

What is sql server programming?

1021