Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: fifth maximum value......

    Hello......


    How to find the fifth maximum value(say ex:mark) of a column in a table using a query....


    Any help.....



    Thanks
    Meena.s

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    use OLAP function

    select P.* from (select row_number() over(order by appliedon desc ) as number ,title,action,appliedon,remark from eone.tdb_patch_dtl ) as P where p.number =5

    --Rahul Singh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •