Select * from Student_Info where Math=(select min(Math)from Student

Display a roll having miminum marks in two subjects?

Question Posted / jiten patel

Answer Posted / jiten patel

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to fine-tune reports?

211

To which devices can a backup be created and where should these devices be located? : sql server management studio

731

What is the importance of three tier architecture?

816

Explain Capacity planning to create a database? and how to monitor it?

3949

List the data types available in mssql?

708

Can I work with several databases simultaneously? : sql server management studio

734

What do you understand by a view?

720

Do you know hot add cpu in sql server 2008?

727

What is an indexing technique?

667

How column data types are determined in a view?

683

What are the types of database recovery models?

787

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1760

Does group by or order by come first?

713

Explain the steps to create and execute a user-defined function in the sql server?

708

What samples and sample databases are provided by microsoft?

759