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 do you understand by physical_only option in dbcc checkdb?
What do you mean by table and field in sql?
Explain use of expression builder.
How do you debug a procedure in sql server?
What is user-defined multi-statement table-valued function?
Why use cursor in sql server?
Can we delete data from a view?
In how many ways you can invoke ssrs reports?
What are the requirements for sql server 2016?
What you can do to delete a table without the delete trigger firing?
What are the Advantages of using CTE in sql server?
How does the report manager work in SSRS?
Explain what is analysis service repository?
What is report snapshot in ssrs?
what is difference between view and Dip.