Top N rows in statement
Top N rows in statement
(OP)
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
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
RE: Top N rows in statement
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
RE: Top N rows in statement
Then I have to go the unconftable way... As we change to another system, we will not upgrade pervasive anymore.
Thank you!