Display a roll having miminum marks in two subjects?

Answer Posted / rajesh

Select * from Student_Info where Math=(select min(Math)from
Student_Info) or Eng=(select min(Eng) from Student_Info)

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete duplicate rows?

627


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1384


Explain few examples of RDBMS?

689


How to rebuild the master database?

683


Why I have to use stored procedures?

696






What are user defined functions in ms sql server?

591


What is page-level compression?

634


When would you use the stored procedures or functions?

678


What are examples of triggers?

708


How to delete a login name in ms sql server?

626


What is a dataset and what are the different types of datasets?

97


What is mean by dml?

645


What are key constraints?

600


Where in ms sql server is ’100’ equal to ‘0’?

709


What are the differences between stored procedure and the dynamic sql?

669