4 Replies Latest reply on Sep 2, 2002 4:29 PM by Marc Sturm

    ejb ql question: (select ... limit 10)

    Marc Sturm Newbie


      I am using JBoss and it is a great tool. To improve performance, I would like to have a ejbFindBy... method that returns a limited number of row. Is it possible to specify using ejb-ql and also using a parameter to specify the number of row you want it to return.

      In postgresql, the sql query would look like:

      SELECT * FROM deliveryejb WHERE status=2 LIMIT 10;

      Thanks for your answer.