Replies: 4 comments 4 replies
-
这种浅谈查询,目前不支持,这样可以 fsql.Select<t>() |
Beta Was this translation helpful? Give feedback.
0 replies
-
还是不行 ,你这个写法 报 Window function is allowed only in SELECT list and ORDER BY clause” |
Beta Was this translation helpful? Give feedback.
0 replies
-
mysql 支持这种开窗函数吗 |
Beta Was this translation helpful? Give feedback.
3 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
var t1 = (from b in
(from a in DB.DBXAdm.Select【User】()
select new { a, rowid = SqlExt.RowNumber().Over().PartitionBy(a.Password).OrderBy(a.Id).ToValue() })
where b.rowid==1
select new { b.a,b.rowid }).ToList();
报 未将对象引用设置到对象的实例。
不加 where b.rowid==1 没报错
Beta Was this translation helpful? Give feedback.
All reactions