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 is a join and explain different types of joins? : Sql server database administration

955

Explain different types of collation sensitivity?

977

what is a deadlock? : Sql server database administration

1058

Can you explain important index characteristics?

987

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

989

How to get a list of all tables with "sys.tables" view in ms sql server?

1032

Your table has a large character field there are queries that use this field in their search clause what should you do?

880

What are the different types of backups that exist?

1163

What is the Disadvantage of indexed sequential file.

1078

Explain what is the purpose of sql profiler in sql server?

1069

How to delete duplicate rows in sql server?

1102

Will sql server 2005 allow you to reduce the size of a column?

986

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

Does the order of columns in update statements matter?

911

Can group functions be used in the order by clause in ms sql server?

1013