Getting the top n records 2

[spuppett]

This is probably a very n00bish question, but I haven't been able to find much. Its hard to do a search on SQL top. I'm looking for a way to get only the first n records back from a SELECT statement. I've seen 'SELECT TOP FROM tbl', but VFP says the statement is invaild, which leads me to believe that top is a vender function, rather then an SQL standard. Is there a way to do this, with out having a program that loops, ie

  SELECT * FROM tbl;
  for i = 0 to n
    do some stuff
  next

Thanks

 

[jimstarr]

Try:

SELECT * TOP n FROM tbl ORDER BY something

Jim

 

[Mike Gagnon]

Can you clarify? Are you querying an SQL table or a DBF table.

SELECT * top(1) FROM ALIAS() ORDER BY 1

Top requires an ORDER BY.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[spuppett]

a dbf table. Thanks for the order by hint