skip to main
|
skip to sidebar
Lost Latest News
Thursday, November 19, 2009
How to get nth highest value from a table
SELECT t.*
FROM (
SELECT *,row_number() over (ORDER BY AccountNo desc) as _Rank
FROM AccountInformation
)as t
where t._Rank=2
Older Posts
Home
Subscribe to:
Comments (Atom)
Blog Archive
▼
2009
(8)
▼
November
(8)
How to get nth highest value from a table
Accessing Web service and delete files
Accessing files
Connection String
Writing SP
Read Text Files
Working with background worker
Example for FolderBrowserDialog
►
2008
(15)
►
May
(1)
►
April
(7)
►
March
(7)
About Me
Iroshan
View my complete profile