sqlserver 语句转 mysql 语句问题

[xiaobudong2458]

请问各位大虾 如下 SQLSERVER 语句是什么意思,用 MYSQL 该怎么表达

SELECT TOP 10 * FROM students WHERE (IDENTITYCOL NOT IN(SELECT TOP 4 IDENTITYCOL FROM students order by IDENTITYCOL)) order by IDENTITYCOL;

[WWWWA]

应该是取按IDENTITYCOL排序，5－14名的学生吧
try:
select * from students limit 4,13
自行修改4,13两个数

[xiaobudong2458]

create 语句里面并没有 IDENTITYCOL 字段

[fmmnu]

MySQL与SQL Server的SQL语法有些地方有所不同，不能照搬。建议查看两者的区别后手工修正。如果不注意，从SQL Server中导出的数据导入MySQL将可能出错。

[ojuju10]

select * from students limit 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;