SELECT row_number()over(order by queryDate) as Id , DISTINCT CONVERT(date, led.CreateTime, 120) AS queryDate, iis.InitIngSum, iis.initUserSum, ids.InitEdSum, ids.ininEnUserSum
row_number()放到 distinct 之后 DISTINCT CONVERT(date, led.CreateTime, 120) AS queryDate,row_number()over(order by queryDate) as Id
还是不行啊,而且加了row_number()over(order by queryDate) as Id ,视图的数据就全部显示出来,而不是distinct
还是不行啊,而且加了row_number()over(order by queryDate) as Id ,视图的数据就全部显示出来,而不是distinct with t as ( SELECT DISTINCT CONVERT(date, led.CreateTime, 120) AS queryDate, iis.InitIngSum, iis.initUserSum, ids.InitEdSum, ids.ininEnUserSum ) select row_number()over(order by queryDate) as Id, * from t
我是按照这个步骤来搞,不过就是添加不进EDMX里面啊
SELECT row_number()over(order by queryDate) as Id , DISTINCT CONVERT(date, led.CreateTime, 120) AS queryDate, iis.InitIngSum, iis.initUserSum, ids.InitEdSum, ids.ininEnUserSum
DISTINCT CONVERT(date, led.CreateTime, 120) AS queryDate,row_number()over(order by queryDate) as Id
with
t as
(
SELECT DISTINCT CONVERT(date, led.CreateTime, 120) AS queryDate, iis.InitIngSum, iis.initUserSum, ids.InitEdSum, ids.ininEnUserSum
)
select row_number()over(order by queryDate) as Id, * from t