Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 68509 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sagesh
SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY mark) AS Stu_Rank
FROM student) As T
WHERE Stu_Rank = 2
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is difference between inner join and full join?
What is global temp table?
what's the difference between a primary key and a unique key? : Sql server database administration
How to copy the tables, schema and views from one sql server to another?
After removing a table from database, what other related objects have to be dropped explicitly?
How to generate create procedure script on an existing stored procedure?
Explain transaction server distributed transaction?
Tell me what is the difference between locking and multi-versioning?
What is an indexing strategy?
What is difference between rownum and row_number?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
How will you optimize a stored procedure optimization?
How to optimize stored procedures in sql server?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is update locks?
