Display a roll having miminum marks in two subjects?
- 7 Answers
- 7549 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / pradip jain
Select * from marks where
(Math=(select min(Math)from
marks) and phy=(select min(phy) from marks))
OR
(Math=(select min(Math)from
marks) and chem=(select min(chem) from marks))
OR
(Phy=(select min(phy)from
marks) and chem=(select min(chem) from marks))
Sonia if it is 3 subject and will be combine with or clause
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
In how many ways you can invoke ssrs reports?
what is bit datatype? : Sql server database administration
Explain what stored procedure sp_replcounters is used for? : sql server replication
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
What’s the use of custom fields in report?
How to call stored procedure using http soap?
What stored by the msdb? : sql server database administration
What is user-defined functions? What are the types of user-defined functions that can be created?
Find columns used in stored procedure?
Tell me what is the difference between locking and multi-versioning?
Do you know what are the reporting services components?
What is the security principal at the server level that represents your session?
What are the steps you should follow to start sql server in single-user mode?
What is a join in sql? What are the types of joins?
