Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Top N rows in statement
- Thread starter medmed
- Start date
I don't think there's really a workaround. You might be able to limit the result set using a WHERE clause and an ORDER BY clause.
I would suggest upgrading to PSQL v10 (or at least v9). It has support for the TOP command and numerous other improvements. It's also a supported product. V7.9 went unsupported in July 2004.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
I would suggest upgrading to PSQL v10 (or at least v9). It has support for the TOP command and numerous other improvements. It's also a supported product. V7.9 went unsupported in July 2004.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question