Top N rows in statement

[medmed]

Hi

I'm currently looking for an option to select the first 50 rows from a table. Within MSSQL the appropriate query would be: SELECT TOP 50 * FROM table

But as i have Pervasive 7.9, this is not supported. Does anybody has a workarounde?

Thanks very much

 

[mirtheil]

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

http://www.mirtheil.com

 

[medmed]

Hi mirtheil

Then I have to go the unconftable way... As we change to another system, we will not upgrade pervasive anymore.

Thank you!