Display a roll having miminum marks in two subjects?
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
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is database white box testing?
List out the differences between the clustered index and non-clustered index in sql server?
What is exclusive locks?
How to use the inserted and deleted pseudo tables?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
Explain the xml support sql server extends?
What is row-level compre?
What happens if you are trying to access a schema not owned by you?
How to delete existing triggers using "drop trigger"?
How do I open port 1433?
What is the difference between a check constraint and a rule?
How to convert numeric values to integers in ms sql server?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is system stored procedures?