When the oracle began to support the "top": choose the top? p2_.PRODUCT_ID of PRODUCT?

Question

When the oracle began to support the "top":

select top ? p2_.PRODUCT_ID from PRODUCT?

Answer 1

I'm not sure that ORACLE had a TOP function. You want to use the TOP-N query.

For example:

select  *
  from  (SELECT  *
           FROM  foo
          where  foo_id=[number]
       order by  foo_id desc)
 where  rownum <= 3   

This will give you the three best results (because I order descending in the subquery)

Answer 2

Oracle does not support the TOP keyword. Request

SELECT TOP 10 product_id
  FROM product

generates a syntax error because the TOP 10 clause is not recognized, at least through Oracle 11.1 (current release).

Answer 3

TOP SQL- Oracle. FIRST_ROWS, , .

, Oracle paudocolumn ROWNUM.