Post reply

dense_rank()

  • January 11, 2013 at 4:43 am

    #99796

    Hello,

    It is possible to use dense_rank() function such that rank to begin with a specified ID ?

    Thank you.

    G.

  • January 11, 2013 at 5:36 am

    #1576218

    dense_rank, like all the windowing functions like row_number,ntile and rank all start with one, so just add your some number to it to get your starting number

    select

    dense_rank() over (order by object_id) + 428600 As Val, *

    from sys.columns

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 11, 2013 at 5:52 am

    #1576231

    Tks.

    G.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply