TOP 100

Question

Is there any SQL that is valid with the FGDB that will help me limit the results returned?
I have tried TOP, LIMIT etc..  but none work.

I could do it all in  code, but I would rather retrieve only the records i need from the table.

I am using the .NET wrapper.

Thoughts?

Drew

DavidSousa · Answer

I believe you will find that SELECT DISTINCT has worked all along.

There are no immediate plans to implement SELECT TOP.  I am not convinced that it is particularly useful.  If you want the equivalent of SELECT TOP 100 * from xyz, why not just keep track of how many rows you have read in and then stop after you hit 100?

TomHoober · Answer

Lance are there any plans to support TOP functionality or any of the SELECT modifiers (ie DISTINCT)? I think its odd that there isn't a way to access full SQL query abilities.  Thanks

LanceShipman · Answer

TOP, LIMIT is not currently supported.