取数据

[Pact_Alice]

--根据VGUID进行分组,每组只取一条数据
--一条数据的得来是：根据IDate，PDate,如果IDate与PDate相同就取日期相同的那条数据
--比如VGUID=63BBE20A-E0A2-4A7C-B2FD-05B772071738 这个单子，IDate是2015-09-01，PDate中有2015-09-01 那么Price就取3.0866
--VGUID='1E8010C7-F417-4653-AA64-08AFF41BB37F'这个单子，IDate=2015-09-01 PDate却没有 2015-09-01 那么就取 PDate为最大的,Price就应该是4.0866
;WITH cet AS (
SELECT '63BBE20A-E0A2-4A7C-B2FD-05B772071738'VGUID, '2015-09-01 00:00:00.000'IDate,'2015-07-01 00:00:00.000' PDate,'1C64B8F3-BC52-4A42-9AC6-4C5555233D4E'TVGUID,'4.0866'Price UNION all
select '63BBE20A-E0A2-4A7C-B2FD-05B772071738','2015-09-01 00:00:00.000','2015-09-01 00:00:00.000','1C64B8F3-BC52-4A42-9AC6-4C5555233D4E','3.0866' UNION ALL
select '63BBE20A-E0A2-4A7C-B2FD-05B772071738','2015-09-01 00:00:00.000','2015-08-01 00:00:00.000','1C64B8F3-BC52-4A42-9AC6-4C5555233D4E','5.0866' UNION ALL
select '1E8010C7-F417-4653-AA64-08AFF41BB37F','2015-09-01 00:00:00.000','2015-08-01 00:00:00.000','1C64B8F3-BC52-4A42-9AC6-4C5555233D4E','4.0866' UNION ALL
select '1E8010C7-F417-4653-AA64-08AFF41BB37F','2015-09-01 00:00:00.000','2015-07-01 00:00:00.000','1C64B8F3-BC52-4A42-9AC6-4C5555233D4E','6.0866'
)
SELECT * FROM cet