Interested to Buy Any Domain ? << Click Here >> for more details...
Display a roll having miminum marks in two subjects?
- 7 Answers
- 8844 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 are the acid properties?
How to transfer data from a cursor to variables with a "fetch" statement?
What is a trigger in sql server?
How to download and install sql server 2005 books online?
Give the query of getting last two records from the table in SQL SERVER?
List out the difference between union and union all in sql server?
What is sharding?
What is the maximum size of a dimension? : sql server analysis services, ssas
What are the differences between having and where clause.
What is indexing explain it with an example?
How do you debug a procedure in sql server?
What is sql view?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What does top operator do?
how we use window authentication connection with sql server.?
