I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / rias
Select MIN(MARK) from student where mark in (select Top 2
mark from student order by mark desc)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the Difference Between Primary and Foreign Key?
What is subreport?
What are transactions and its controls?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How can you list all the columns in a database?
Does transparent data encryption provide encryption when transmitting data across the network?
What are user-defined functions (udfs) in sql server?
What are different types of raid levels?
Explain trigger and trigger types?
can you instantiate a com object by using t-sql? : Sql server database administration
What are the different types of stored procedures?
How to declare a cursor with "declare ... Cursor" in ms sql server?
Can we insert data if clustered index is disabled?
What is the use of commit?