DB2 可以用如下的语法吗？？

[lpc007]

SELECT * FROM news where class=140 and bz=1 ORDER BY id DESC LIMIT 10

主要是能不能用LIMIT

[welyngj]

mysql的语法在db2是错误的。

SELECT * FROM news where class=140 and bz=1 ORDER BY id DESC
fetch first 10 rows only

[伍子V5]

fetch first 10 rows only