SELECT col1, max(col2), Max(col3)
FROM TableA
GROUP BY col1

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

declare @data 
    table
    (
    room_name       varchar(20) not null,
    session_name    varchar(20) not null,
    event_date      datetime not null,
    delegate        varchar(30) not null
    );

insert  @data (room_name, session_name, event_date, delegate) 
values  ('Test Room', 'Test Session', '2009-11-15 08:00:00', 'Ahmad Awada');

insert  @data (room_name, session_name, event_date, delegate) 
values  ('Test Room', 'Test Session', '2009-11-15 08:00:00', 'Ahmad Awada');

insert  @data (room_name, session_name, event_date, delegate) 
values  ('Test Room', 'Test Session', '2009-11-15 08:00:00', 'Alastair Kyle');

insert  @data (room_name, session_name, event_date, delegate) 
values  ('Test Room', 'Test Session', '2009-11-15 08:00:00', 'Alastair Kyle');

insert  @data (room_name, session_name, event_date, delegate) 
values  ('Test Room', 'Test Session', '2009-11-15 13:30:00', 'David Rimm');

insert  @data (room_name, session_name, event_date, delegate) 
values  ('Test Room', 'Test Session', '2009-11-15 13:30:00', 'Frédérique Penault-Llorca');

insert  @data (room_name, session_name, event_date, delegate) 
values  ('Test Room', 'Test Session', '2009-11-15 13:30:00', 'Giuseppe Viale');

-- Idea 1
with    NumberedRows
as      (
        select  *,
                rn = ROW_NUMBER() OVER (PARTITION BY event_date ORDER BY delegate)
        from    @data
        )
select  event_date, room_name, session_name, delegate
from    NumberedRows
where   rn <= 4;

-- Idea 2
select  D.event_date, CA.room_name, CA.session_name, CA.delegate
from    (
        select  event_date
        from    @data 
        group   by event_date
        ) D
cross
apply   (
        select  top (4)
                *
        from    @data D2
        where   D2.event_date = D.event_date
        order   by
                delegate
        ) CA;

We walk in the dark places no others will enter
We stand on the bridge and no one may pass