I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61307 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / shrikant
I have student marks in a student table. I need all record
where second highest mark .Then what will the query for this?
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are sql servers used for?
How to remove duplicate rows from table?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is it’s similarity with sql server?
What are the fixed server level roles? : sql server security
What is the purpose of the tempdb database?
What are built in functions?
what is a transaction? : Sql server database administration
What is the difference between a primary key and a unique key? Are they the same?
What is the difference between coalesce() & isnull()?
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is surrogate key? : sql server analysis services, ssas
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What happens if the update subquery returns no rows in ms sql server?
