Display a roll having miminum marks in two subjects?
- 7 Answers
- 7550 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / ivee
Suppose we are having a table called abc which has field
name as marks, subject and roll
now roll2 and roll3 has the same minimum marks as 40
so the query will be
select roll from abc where marks=(select min(marks) from
abc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Benefits of Stored Procedures?
What is the bookmark lookup and rid lookup?
Explain the types of indexes.
What is a matrix in ssrs?
Explain system views?
What are the different types of replication are there in sql server 2000?
What are different types of subquery?
How to connect to SQL Azure Database by using sqlcmd?
What is the difference between deallocate cursor and close cursor?
What are trace files?
If a stored procedure is taking a table data type, how it looks?
if no size is defined while creating the database, what size will the database have? : Sql server administration
Tell me the difference between clustered and non-clustered index?
Can you explain about buffer cash and log cache in sql server?
Explain the flow of creating a cube? : sql server analysis services, ssas
