Post reply

nested query in msaccess

  • September 30, 2009 at 5:19 am

    #156268

    Hi,

    I hv a table called myTable

    which hold record like this,

    BLOCK_ID TOTAL

    10

    219.22641

    55100

    5587.40159

    5562.51066

    13.219

    20.099

    553.219

    131.0688

    225

    5534.12

    20

    110.73267

    210.97707

    5510.97707

    185.94

    Can I have top 2 total from each block_id in one single query ?

    Thanks

    [font="Verdana"]Regards
    Kumar Harsh[/font]

    :unsure:

  • September 30, 2009 at 5:27 am

    #1059879

    If you are asking for help writing SQL in Access, why are you posting in a forum for SSIS?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • September 30, 2009 at 5:37 am

    #1059884

    Hi,

    Sorry my mistake.

    [font="Verdana"]Regards
    Kumar Harsh[/font]

    :unsure:

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

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