Post reply

Query in Sql 2000

  • January 27, 2011 at 1:07 am

    #234026

    I've a table with two columns C1 and C2 and having following data in it.

    C1 C2

    --------------

    A1

    A3

    A4

    A7

    B1

    B2

    B3

    C1

    C2

    C3

    C5

    I want to write query which should return all the missing sequence per group like below:

    A 2

    A 5

    A 6

    C 4

    Thanks in Advance.

  • January 27, 2011 at 5:05 am

    #1279001

    Google Number/Tally table.

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

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