SELECT TOP n

[rbbutz]

Hi All,

Was wondering how to use 'SELECT TOP n * FROM [tablename]'.

Or an equivalent function.

Using sequelink odbc driver 5.4 on win2003.

Any help would be greatly appreciated!!

[mattley]

Before your select use

SET ROWCOUNT = n

And use ORDER BY to get the the top n for that column

[angelleye]

I'm trying to do this exact same thing right now and I'm having trouble following your reply Mattley.

here's what I did based on what you said:

SET ROWCOUNT = 5 SELECT zID FROM Leads_and_Clients WHERE Name = 'Full Name' ORDER BY zID DESC

I'm getting a parse error. Any info would be greatly appreciated. Thanks!

Edited February 20, 2007 by Guest

[Kranky]

According to the Filemaker documentation (FM8_ODBC_JDBC_Developer.pdf), SET ROWCOUNT is not a supported SQL statement.

Neither are LIMIT or TOP.