"Karen Hill" <karen_hill22@xxxxxxxxx> 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. regards, tom lane
