Jump to content

FM equivalant of SELECT TOP 10...???


This topic is 6246 days old. Please don't post here. Open a new topic instead.

Recommended Posts

In Access I can use the following SQL statement to return only the last 10 records in the table.

SELECT TOP 10 zID FROM Customers

FileMaker gives me a parsing error on this. In my research I see that MySQL and Oracle have different syntax for this. Does FileMaker have something I can use for this feature?

Any information would be greatly appreciated. Thanks!

Link to comment
Share on other sites

Does FileMaker have something I can use for this feature?

Any information would be greatly appreciated. Thanks!

Well I know that your issue was with the SQL, but the last part of your post seemed as though you were looking for an alternative.

Link to comment
Share on other sites

This topic is 6246 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.