如果是Oracleselect ID,titile,content,goodvote,createdate
from table_name
where rownum<=20
order by createdate desc,goodvote desc其它数据库在选取记录段稍有不同
from table_name
where rownum<=20
order by createdate desc,goodvote desc其它数据库在选取记录段稍有不同
要不用程序来实现,估计效率不会比sql高
要提高性能,就把*换成具体的字段,oracle不用来解析这个*号,这样会提供些性能
你具体的需求是什么?
SELECT * FROM table order by createdate desc,goodvote desc limit 20