LIMIT with Select Statement

[Devang]

Hi   Is it possible to use  “LIMIT”  keyword with select statement? Or is there any other alternative for the same?   Thanx   Devang