Results 1 to 2 of 2

Thread: Ranking functions: how are you using them?

  1. #1
    Join Date
    Dec 2006
    Portland, Oregon

    Question Ranking functions: how are you using them?

    [This thread is associated with Parts 19 and 20 of the SQL Credit series.]

    How are you using ranking functions in your applications?

    I explained in Part 20 how I have been using ROW_NUMBER() (see the section "A Real-World ROW_NUMBER() Example").

    Please share your experience.

    Last edited by rgarrison; 10-24-2008 at 10:59 AM. Reason: Added article links

  2. #2
    Join Date
    Sep 2009

    Use of Rank Functions

    I heard in this forum that amongst the Ranking Functions, NTILE(n) does not show any use. Well, i think this is a best fit for paginations in Reporting modules. The same is also possible using ROW_NUMBER, but i said best fit for NTILE(n). Think over it.

Posting Permissions

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