CREATE TABLE tb(日期datetime, 料号 NVARCHAR(30), 单价int)
INSERT tb SELECT '2008/5/1','AAA',2
UNION ALL SELECT '2008/6/6','BBB',22
UNION ALL SELECT '2008/6/6','CCC ',12
UNION ALL SELECT '2008/7/3','BBB',21
UNION ALL SELECT '2008/7/9','AAA ',1
现要求得到如下结果:
日期 料号 单价
2008/6/6 CCC 12
2008/7/9 AAA 1
INSERT tb SELECT '2008/5/1','AAA',2
UNION ALL SELECT '2008/6/6','BBB',22
UNION ALL SELECT '2008/6/6','CCC ',12
UNION ALL SELECT '2008/7/3','BBB',21
UNION ALL SELECT '2008/7/9','AAA ',1
现要求得到如下结果:
日期 料号 单价
2008/6/6 CCC 12
2008/7/9 AAA 1
2008/7/3 BBB 21
望大家帮帮忙.....