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 2nf in normalization?

1050

what is hash nonclustered index

1019

What is the purpose of the tempdb database?

1042

Describe how to use the linked server?

1198

Do you know the isolation level that sql server support?

1000

How to create new tables with "select ... Into" statements in ms sql server?

1042

What command must you use to include the not null constraint after a table has already been created?

1227

which backup strategy you are following at ur company

2190

State a few properties of relational databases?

1177

Explain the use of containers in ssis?

1011

How are the exceptions handled in sql server programming?

1114

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1181

Why is replication required on the sql server?

1103

What are filegroups in sql server?

1097

Which is the latest version of sql server and when it is released?

1187