Display a roll having miminum marks in two subjects?
- 7 Answers
- 7831 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
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
Does group by or order by come first?
What is temporary stored procedure?
How to define the name and server for a new dsn?
Can you please explain the difference between primary keys and foreign keys?
How do I know if localdb is running?
What is difference between count (*) and count 1?
What are the differences between stored procedure and the dynamic sql?
What’s the distinction between dropping a info and taking a info offline?
What are the tables in sql?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
How to execute stored procedure and set temp table in sql server?
What is difference between count (*) and count column?
What is the difference between createstatement and preparedstatement?
Explain active/passive and active/active cluster configurations?
