Display a roll having miminum marks in two subjects?
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 does executeupdate return?
What are the 3 types of schema?
Tell me what is the significance of null value and why should we avoid permitting null values?
What is transaction server distributed transaction?
how to create “alternate row colour”?
between cast and convert which function would you prefer and why?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What do you do in data exploration
How to move database physical files in ms sql server?
What is primary key and example?
What should be the fill factor for indexes created on tables? : sql server database administration
Why I am getting this error when dropping a database in ms sql server?
What are partitioned views?
Can I delete event logs?
What are the dmvs? : sql server database administration