一个分组的问题吧。

Question

数据是这样子的，
nodeno,account,filenamelog,filetime,commtime
14000274,2007-4-25 7:15:43,3270085620070425071543000000.erroilvouch,2007-4-25 7:15:49,2007-4-26 20:33:21
filenamelog的名字，同一天的是一样的，只是后面的不一样(.后面的)
要求：
排成 名.a,名.b,名.c这种文件形式，能得出来吗？

Answer 1

不知道我理解的对不对,你试一下,我用的是sqlserver数据库:
create table tt(nodeno int,account datetime,filenamelog varchar(100),filetime datetime,commtime datetime);
insert into tt values(
14000274,'2007-4-25 7:15:43','3270085620070425071543000000.erroilvoudd','2007-4-25 7:15:49','2007-4-26 20:33:21')insert into tt values(
14000275,'2007-4-25 7:15:43','3270085620070425071543000000.erroilvouaa','2007-4-25 7:15:49','2007-4-26 20:33:21')insert into tt values(
14000276,'2007-4-25 7:15:43','3270085620070425071543000000.erroilvoubb','2007-4-25 7:15:49','2007-4-26 20:33:21')insert into tt values(
14000280,'2007-4-26 7:15:43','3270085620070425071543000000.erroilvoudd','2007-4-25 7:15:49','2007-4-26 20:33:21')insert into tt values(
14000279,'2007-4-26 7:15:43','3270085620070425071543000000.erroilvouaa','2007-4-25 7:15:49','2007-4-26 20:33:21')insert into tt values(
14000278,'2007-4-27 7:15:43','3270085620070425071543000000.erroilvoubb','2007-4-25 7:15:49','2007-4-26 20:33:21')
select * from tt
order by account,substring(filenamelog,charindex('.',filenamelog)+1,len(filenamelog)-charindex('.',filenamelog))