If you are using mysql you want to use a LIMIT clause. If you are using SQL Server you want to use a TOP condition. If you are using something else, you could try telling us what you're using, and what you have tried. You said "everything i have tried..." but you didn't actually show that you tried anything. Hope the limit or top solves your problem, if not though please provide more detail.
