limit in where

Question

do exist limit of "where condition" ?

Answer 1

Not sure what you are asking, but you can use both WHERE and LIMIT at the same time, and LIMIT is applied to the results that match the WHERE condition.

SELECT * FROM mytable WHERE mycolumn = 50 LIMIT 100;

Answer 2

Limit is used for... How many records u want
to see.. Then use limit statement... Its similar to select top in my sql..