Where is Comment Limit Set

Hello, im hacking up my comments… im showing the latest comment for each post on the homepage… i just need to set it to retrieve one comment per post… can someone tell me where i can find the sql for this or where this variable is set? in the .php files.
~ Mauricio