Interested to Buy Any Domain ? << Click Here >> for more details...
Display a roll having miminum marks in two subjects?
- 7 Answers
- 8856 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
What are different types of raid configurations? : SQL Server Architecture
Can we check locks in database? If so, how can we do this lock check?
How do I debug a stored procedure in sql server?
What are relationships and mention different types of relationships in the dbms
How to create function without parameter in sql server?
List out the difference between union and union all in sql server?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Which is the latest version of sql server and when it is released?
How to create a stored procedure with a statement block in ms sql server?
What is a natural primary key?
What is transaction server implicit?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
How many types of triggers are there?
What is a View ? Can we insert, Update and delete a view?
How does recursive cte works in sql server?
