Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    11

    Unanswered: display info on different rows

    i have to display the 10 most costly missions. but if the 11th record has the same cost then it needs to display 11 records instead of 10. how can i do this?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Investigate use of RANK and DENSE_RANK analytical functions.

Posting Permissions

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