mysql - 从 mysql 中的表中选择最后 n 行而不使用 order by

Question

select * from employee limit select count(*)-1 from employee,1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select count(*)-1 from employee,1' at line 1

Answer 1

希望这个工作

select * from your_table except 
select top ((select count(*) from your_table) - how many rows you want)* from your_table