List:General Discussion« Previous MessageNext Message »
From:Jose de Leon Date:December 29 1999 1:25am
Subject:LIMIT clause
View as plain text  
Does the LIMIT clause in a select actually limit the number of rows actually
selected or does it limit only the number of rows returned?

The reason I ask is because I am running a query that is selected over
100,000 rows but no matter how I specify LIMIT, it always chokes the server.

If LIMIT only limits rows returned, then how can I get around that and force
only a small amount of rows selected?


LIMIT clauseJose de Leon29 Dec
  • Re: LIMIT clausePaul DuBois29 Dec
  • Re: LIMIT clausehypnos29 Dec