MergeTable Queryable cannot Take Skip OrderBy PageToList 返回
beliefchen 发布于2019/1/23
想要实现以下的SQL，但是却出现错误:MergeTable Queryable cannot Take Skip OrderBy PageToList
/*
string sql = " Select Distinct(SID) from(" +
" Select *, ROW_NUMBER() Over (Partition By SID Order By TDate Desc, TradeSN desc) As Sort" +
" from TradeRecord Where TDate <= @TDate)A Where A.Sort = 1 and A.HoldNum != 0";
*/
return sqlClient.Queryable<TradeRecord>()
.PartitionBy(it => it.SID)
.Where(it => SqlFunc.ToDate(it.TDate) <= SqlFunc.ToDate("2018/01/01"))
.OrderBy(it => it.TDate, OrderByType.Desc)
.OrderBy(it => it.TradeSN, OrderByType.Desc)
.Take(1)
.Select(it=>it)
.MergeTable()
.Where(it=>it.HoldNum!=0)
.Select(it => it.SID).ToList();
热忱回答（3）
-
fate stay night VIP0
2019/1/23take和orderby需要写到 MergeTable后面
0 回复 -
beliefchen VIP0
2019/1/23
一样错误
0 回复 -
fate stay night VIP0
2019/1/24
Parttionby不支持吧
0 回复