Home Forums SQL Server 2008 SQL Server 2008 - General how to result query with repeat sequence number RE: how to result query with repeat sequence number

  • March 5, 2015 at 9:56 pm

    #1782083

    happycat59 (3/5/2015)

    Try something like

    select

    Field1

    , Field2

    , DENSE_RANK () OVER (ORDER BY Field1) AS SeqNo

    FROM YourTable

    yes.. it's get repeated seqno now based on field1, but it's sorted by field1.

    it's not the normal order from source table