Display a roll having miminum marks in two subjects?
- 7 Answers
- 7829 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
Do you know what is lock escalation?
What is a synonym for manipulation?
in the physical file layout, where should the transaction log be stored in relation to the data file?
How do I find the port number for sql server?
What are the properties of primary key?
What are different types of data sources?
How real and float literal values are rounded?
What is normalization? Explain different forms of normalization?
What happens when the SQL Azure database reaches Max Size?
What are indexes in sql?
What is collation sensitivity? Explain different types.
What do you mean by recursive stored procedure?
Find columns used in stored procedure?
How retrieve field names from the table in SQL through JAVA code?
Explain the architecture of ms sql reporting service?
