Oracle,mysql,sqlserver,postgresql语句几点比较
1.分页
Oracle:
SELECT * FROM(SELECT A.*, ROWNUM RN FROM (select T.* from sj_receiptinfo t WHERE t.TAXNO LIKE CONCAT('%', CONCAT(?, '%')) order by t.id desc) A WHERE ROWNUM ?
mysql:
select * fr
原创
2015-03-15 16:06:12 ·
1266 阅读 ·
0 评论