limit 的一个问题 id #1727

New Issue

344085057 · 2020-06-27T08:27:10Z

344085057 commented

2020-06-27 08:27:10 +00:00

v1.0.2
sql server


SELECT TOP 10 [name], [code], [sys_cont_id] FROM [view_lcmodel] WHERE (id NOT IN (SELECT TOP 10 id FROM [view_lcmodel]))

表中没有id我该怎么办？

v1.0.2 sql server ```sql SELECT TOP 10 [name], [code], [sys_cont_id] FROM [view_lcmodel] WHERE (id NOT IN (SELECT TOP 10 id FROM [view_lcmodel])) ``` 表中没有id我该怎么办？

344085057 commented

2020-06-27 08:27:57 +00:00

我尝试使用 ID("code")
没有效果

id是固定死的吗？

我尝试使用 ID("code") 没有效果 id是固定死的吗？

lunny added the

kind

bug

label 2020-06-27 13:10:57 +00:00

lunny commented

2020-07-09 01:51:36 +00:00

mssql pagination is a problem.

lunny added the

upstream

label 2021-06-09 03:35:49 +00:00

lunny added the

db

sqlserver

label 2021-08-04 08:54:04 +00:00

Sign in to join this conversation.

No Milestone

No Assignees

2 Participants

Notifications

Due Date

The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: xorm/xorm#1727