how to find the seventh largest number in a column

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • karthickkuchanur
    New Member
    • Dec 2007
    • 156

    how to find the seventh largest number in a column

    how to find the seventh largest number in a column
    for example
    1,2,3,4,5,6,7
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    try to use rownum after sorting the column.

    Comment

    Working...