Home Forums SQL Server 2005 T-SQL (SS2K5) Group by clause on partial select RE: Group by clause on partial select

  • November 6, 2009 at 4:19 pm

    #1076176

    Gail,

    Here is my data:

    TestRoomtest session 22009-11-15 08:00:00.000AhmadAwada

    TestRoomtest session 22009-11-15 08:00:00.000AhmadAwada

    TestRoomtest session 22009-11-15 08:00:00.000AlastairKyle

    TestRoomtest session 22009-11-15 08:00:00.000AlastairKyle

    Veteran-s Educational 2009-11-15 13:30:00.000DavidRimm

    Veteran-s Educational 2009-11-15 13:30:00.000Frédérique Penault-Llorca

    Veteran-s Educational 2009-11-15 13:30:00.000GiuseppeViale

    I need to get the first 4 records in a result set . How do i do it?

    I cannot select top 4 because after the date expires it could be 1 record or it could be 5.

    Thanks for your help.