Interested to Buy Any Domain ? << Click Here >> for more details...
Display a roll having miminum marks in two subjects?
- 7 Answers
- 8681 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
What is the difference between composite index and covering index?
Explain various On-Delete options in a DB table. Which is the default option?
Explain throw statement in sql server 2008?
What are the difference between clustered and a non-clustered index?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is public role in sql server?
What do you understand by the data quality services in sql server?
Explain about SQL server 2005?
what are constraints? Explain different types of constraints? : Sql server database administration
How to copy the tables, schema and views from one sql server to another?
Explain system views?
List the ways in which dynamic sql can be executed?
What stored by the tempdb ? : sql server database administration
What is t-sql script to take database offline – take database online.
