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

What is order of B+tree?

859


What is difference between count (*) and count 1?

678


What do you understand by replication in sql server?

746


Explain how many normalization forms?

752


What kind of problems occurs if we do not implement proper locking strategy?

1141






What are the properties of primary key?

715


What is #table in sql server?

742


How to check parameter value in stored procedure sql server?

656


What triggers long term care?

716


Do you know what is openxml in sql server?

806


What is the purpose of the tempdb database?

747


What are the recovery models in sql server 2000?

710


When would you use sql joins?

687


What is create command?

700


Where do we use trace frag?

731