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

37 Answers
68783 Views
NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between views and stored procedures?

992

Does a full backup include transaction log?

980

what is the primary use of the model database? : Sql server administration

1051

What are data regions?

136

Differentiate between truncate vs delete in mssql?

1086

How do I find query history in sql server?

947

what is difference between view and Dip.

2412

How to delete duplicate rows?

1000

Would you store your query in a ssrs report or a database server? State the reason why?

152

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

1006

What is difference between count (*) and count 1?

932

Explain foreign key in sql server?

1032

How to create stored procedures with parameters in ms sql server?

1083

What is a functions and types in sql server?

1090

What is a fan-out query in SQL Azure?

121