ID name AddDate
1015 CEC 598 2004-10-04 19:28:56.000
2371 CEC 736H 2004-12-16 17:47:53.000
1001 CEC 969 2004-10-04 18:58:51.000
1020 CEC A606 2004-10-28 21:32:45.000
1044 CEC A706 2005-01-11 17:42:45.000
2322 CEC B820 2005-01-11 18:46:50.000
2325 CEC B850 2005-01-11 18:47:25.000
1022 CEC C600 2005-01-11 17:35:40.000
1023 CEC CF16 2004-10-04 19:40:22.000
1003 CEC DW3288 2004-10-04 19:04:03.000
1025 CEC e2800(+) 2005-01-11 17:34:48.000
1026 CEC E68 2004-10-04 22:18:27.000
1038 CEC S320 2005-01-11 17:34:07.000
2360 CECT 620 2004-12-17 09:57:21.000
466 LG 2120 2004-10-27 15:48:03.000
2644 LG C260 2005-02-14 13:45:17.000
2376 LG c3100 2004-12-16 11:41:39.000
1015 CEC 598 2004-10-04 19:28:56.000
2371 CEC 736H 2004-12-16 17:47:53.000
1001 CEC 969 2004-10-04 18:58:51.000
1020 CEC A606 2004-10-28 21:32:45.000
1044 CEC A706 2005-01-11 17:42:45.000
2322 CEC B820 2005-01-11 18:46:50.000
2325 CEC B850 2005-01-11 18:47:25.000
1022 CEC C600 2005-01-11 17:35:40.000
1023 CEC CF16 2004-10-04 19:40:22.000
1003 CEC DW3288 2004-10-04 19:04:03.000
1025 CEC e2800(+) 2005-01-11 17:34:48.000
1026 CEC E68 2004-10-04 22:18:27.000
1038 CEC S320 2005-01-11 17:34:07.000
2360 CECT 620 2004-12-17 09:57:21.000
466 LG 2120 2004-10-27 15:48:03.000
2644 LG C260 2005-02-14 13:45:17.000
2376 LG c3100 2004-12-16 11:41:39.000
select id,name,adddate from product order by name,adddate desc
这两种应该不会错的啊,我试了不会错的
--请看,注意第三、四行,declare @tab table(id int,name varchar(20),AddDate datetime)
insert @tab
values(1020,'CEC A606','2004-10-28 21:32:45.000')
insert @tab
values(1044,'CEC A706','2005-01-11 17:42:45.000')
insert @tab
values(2322,'CEC B820','2005-01-11 18:46:50.000')
insert @tab
values(2325,'CEC B820','2005-01-15 18:47:25.000')
insert @tab
values(466,'LG 2120','2004-10-27 15:48:03.000')
insert @tab
values(2644,'LG C260','2005-02-14 13:45:17.000')
insert @tab
values(2376,'LG c3100','2004-12-16 11:41:39.000')
--select * from @tab
select id,name,adddate from @tab order by name,adddate asc让,分出先后时间。
--你的同一系列,应该不是相同的名字,所以得不到你想要的结果。
--同一系列的产品名字,是分别以CEC、LG开头的吗???这样的名字不好排序啊
这样应是对的,能实现楼主功能,是不是在其它还有问题,看看数据是不是存在问题?