给大家模拟的表和数据
create table kaoqin ( userid varchar(4) not null, holeid varchar(2) not null, recodetime nvarchar(20) not null )
insert into kaoqin values('0001','05','2013-08-22 13:52:21')
insert into kaoqin values('0002','01','2013-08-22 13:52:18')
insert into kaoqin values('0002','06','2013-08-22 13:52:21')
insert into kaoqin values('0003','08','2013-08-22 13:52:35')
最后的结果我是要一次性 查询出 '0001','05','2013-08-22 13:52:21' | '0002','06','2013-08-22 13:52:21' |'0003','08','2013-08-22 13:52:35'