SQL statements are only different from database to database, has nothing to do with JSP or ASP.

If you are using the same database, you meight made mistakes somewhere else.

Just a guess.

For exampel, in Oracle you need to use the following to do the same thing

SELECT *

FROM (SELECT column_names

FROM table_name

ORDER BY column_name DESC)

WHERE ROWNUM <= 10

"select * from (select b2name from b2 order by id desc ) where ROWNUM <= 10";

显示     参数不足，期待是 1。
不明白~~  

Hey, I don't have an Oracle to test on hand, I got it from internet. However, the original is 1, I was not sure why.

Try 1 to see what happens.

[b]"select * from (select b2name from b2 order by id desc ) where ROWNUM <= 1";[/b]

Let me know.