Question

如何将SQlserver语句 转化成mysql语句

select top 3 *from heshan where userId not in(select top 6 userId from heshan）

Answer 1

CREATE PROCEDURE getNextSeq2 tableName varchar(255),out nextseq numeric(10),out lastseq numeric(10)
begin
update CAREFX_TABLE_SEQ
set lastseq = seq = seq + 10
where table_name=tableName;
set nextseq = lastseq-10;
set lastseq = lastseq-1;
end;

如果对您有帮助，请记得采纳为满意答案，谢谢！祝您生活愉快！

Answer 2

select * from heshan
where userId not in(select userId from heshan limit 0,5）
limit 0,2