Hi,

Can any one tell, how to display nth highest record in a table for example? How to display 4th highest (salary) record from customer table?

Thanks

Hi Karthik,

The following articles discuss these issues:

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>Can any one tell, how to display nth highest record in a table for example?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
blog.sqlauthority.com/2008/03/12/sql-server-2005-find-nth-highest-record-from-database-table-using-ranking-function-row_number/

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>How to display 4th highest (salary) record from customer table?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
www.sqlteam.com/article/find-nth-maximum-value-in-sql-server

I hope that you will find them useful.

Regards,


Georgi Kralev

Homepage: gdkralev.googlepages.com

Hi Georgi,

Thanks for the reply, the links helped me to get a solution for the problem.<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks & Regards,
Karthik

Edited by - ksindev on 07 Aug 2008 12:51:56