Tom Lane wrote:
> "Karen Hill" <karen_hill22@yahoo.com> writes:
> > It seems PostgreSQL doesn't have a TOP Predicate. Why is that?
>
> It's not in the SQL standard. If we were to implement something like
> what I think you're asking for (your example is way underspecified),
> it'd probably look like SQL2003's window functions.
>
Hi Tom,
The TOP predicate seemed to be really common in some other RDBMS. I
guess it isn't in the standard since oracle seems to be missing it in
9i. Maybe 10g has it.
http://www.oracle.com/technology/tech/migration/ama/exchange/docs/ss2k/SELECTStatement.htm