SQL: how to limit number of records in select?

I'm using paradox tables.  I wish to limit the number of returned records from a SQL select satement (the first 40 records) with varying ORDER BY parameters.
Can I do this?
rwvAsked:
Who is Participating?
 
ShakariConnect With a Mentor Commented:
you can add to select a count command

select * from table1 order by field where count<41
0
 
lgmmCommented:
the only way to do this is that you add a field in your end query  and use a statement in where

where field <= 40

im not sure if in delphi exists the recno() function , is similar the use

0
 
shenqwCommented:
It's difficult to do that use only SQL in Paradox,Easy in Oracle & Ms SQL.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.