Retrieving limited records from database

[#1]

Hi All,

How to retrieve limited records from database.

Kindly help me any one.

Thanks in Advance,

Ram.

[swuehl]

Not sure if I fully understand, but you can limit the records by using a WHERE clause, like:

SELECT FieldA FROM DB WHERE FieldA > 0;

[tresesco]

you can use First like:

First 100

Load * from ...;

this will pull first 100 records from your source