SQL Server:
select top 8 * from stu_info order by idx
MySQL:不支持top关键字
select * from `stu_info` order by idx desc limit 8
sql server与mysql使用的一个小细节
Author: wangsy
Link: https://wangsy.me/2013/csdn-11828771-79f876a0/
本文采用知识共享署名-非商业性使用 4.0 国际许可协议进行许可
select top 8 * from stu_info order by idx
select * from `stu_info` order by idx desc limit 8
Author: wangsy
Link: https://wangsy.me/2013/csdn-11828771-79f876a0/
本文采用知识共享署名-非商业性使用 4.0 国际许可协议进行许可