nth record of table
Posted: Sat Jan 07, 2006 11:45 am
how do i get the nth matching record of the query.....i dont know the unique id in the query, so all i can do is find the nth record...
select *
from address
where address.street = "main street"
in this query, there is likely to be a bunch.....but i want the query to return only one each time...
thanks so much for any help!
select *
from address
where address.street = "main street"
in this query, there is likely to be a bunch.....but i want the query to return only one each time...
thanks so much for any help!