Pervasive 11 "Top" or "First"

I am trying to pull the top, or first, record from a table... how can I do this in Perv 11?

Sheldon LivingstonConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bill BachPresident and Btrieve GuruCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mirtheilSoftware DeveloperCommented:
Pervasive v11 supports the TOP keyword.  You would need to add an ORDER BY to sort on the field you want for the first record.  

For example, this query will return the first record from the Class table sorted by the Start_Date:
select top 1 * from class order by start_date

Open in new window

Sheldon LivingstonConsultantAuthor Commented:
Does this infer that you CANNOT specify the field?

select top 1 FRDATE from class order by start_date
mirtheilSoftware DeveloperCommented:
Specifying the field in the select list will only return that field.
"select top 1 FRDATE from class"
will only return the first value for FRDATE.
Sheldon LivingstonConsultantAuthor Commented:
Thanks for you help!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.