请问各位大虾 如下 SQLSERVER 语句是什么意思,用 MYSQL 该怎么表达SELECT TOP 10 * FROM students WHERE (IDENTITYCOL NOT IN(SELECT TOP 4 IDENTITYCOL FROM students order by IDENTITYCOL)) order by IDENTITYCOL;
调试欢乐多
try:
select * from students limit 4,13
自行修改4,13两个数
order by IDENTITYCOL;
SELECT a.* FROM students as a right join
(
SELECT s.IDENTITYCOL FROM students as s order by s.IDENTITYCOL limit 4
) as b
on a.IDENTITYCOL = b.IDENTITYCOL WHERE a.IDENTITYCOL is NULL
order by IDENTITYCOL limit 10;