以下为各种数据库获取前n条记录的写法,仅供参考
pg:--->select name from t_personal order by personal_id desclimit 10
SQLSERVER:--->sselect top 10 ***
db2:--->sselect * from table_name fetch first 10 rows only
oracle:--->sselect * from table_name where rownum < 10
以下为各种数据库获取前n条记录的写法,仅供参考
pg:--->select name from t_personal order by personal_id desclimit 10
SQLSERVER:--->sselect top 10 ***
db2:--->sselect * from table_name fetch first 10 rows only
oracle:--->sselect * from table_name where rownum < 10