Thanks, but what I want to do is check if a number is in the first 3,
not return the first three. If returning the first three and seeing if
any of them matches is the only way, I'll do that, but it doesn't seem
that great for the server.
SELPH,JASON (HP-Richardson,ex1) wrote:
select myfield
Generally, you want to use the LIMIT function.
SELECT num FROM myfile ORDER BY num LIMIT 3;
However, if the values may be repeated (e.g., 1,1,1,2,4,4,5), the query
above will return 1,1,1.
If you are interested in the three lowest values and not just smallest
entries, add DISTINCT
SELECT