Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Limit Number of Records
Thu, Nov 7 2013 11:52 PMPermanent Link

Ben Sprei

CustomEDP

How can someone limit the number of records returned by a query.  Say 1000
records fit the select criteria.  I only want to see one.  Select TOP or
LIMIT does not work

Ben

Fri, Nov 8 2013 3:11 AMPermanent Link

Uli Becker

Ben,

> How can someone limit the number of records returned by a query.  Say 1000
> records fit the select criteria.  I only want to see one.  Select TOP or
> LIMIT does not work

You have to use RANGE

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=SELECT

Uli
Image