with temptab as ( select row_number() over(order by substring(marks,1,2))

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / poomanibe

Answer Posted / poomanibe

with temptab as
(
select row_number() over(order by substring(marks,1,2)) as
rownum,* from Student
)
select * from temptab where rownum=1

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What do you mean by an execution plan?

774

Name some of the open source software that you can use in alternative to SSR?

134

How to get @@error and @@rowcount at the same time?

769

what is a traditional network library for sql servers? : Sql server database administration

636

How do I save a stored procedure in sql server?

668

What is difference between primary key and foreign key?

647

What are the advantages of using cte?

742

What is extended stored procedures?

716

How to convert numeric expression data types by assignment operations?

721

What is self join in sql server joins?

733

How do you troubleshoot errors in a SQL Server Agent Job?

744

What are xml indexes?

696

How do I delete a sql server database?

720

What are the new features in sql server 2016?

706

How can I create a report based on a query? : sql server management studio

758