Results 1 to 2 of 2

Thread: Ranking functions: how are you using them?

  1. 10-23-2008, 07:28 PM #1
    rgarrison
    rgarrison is offline Registered User
    Join Date
    Dec 2006
    Location
    Portland, Oregon
    Posts
    64

    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.

    Thanks,
    Rob
    Last edited by rgarrison; 10-24-2008 at 10:59 AM. Reason: Added article links
    Reply With Quote Reply With Quote
  2. 11-13-2009, 07:16 AM #2
    swapnilsbagul
    swapnilsbagul is offline Registered User
    Join Date
    Sep 2009
    Posts
    1

    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules