Insert and limit

Hi all,
 is possible that the limit statement dosen't run correctly in this case:
 
Insert into temp
Select * from tab1
Where cod = xxxx
Limit yyy;
 
Thanks in advance !Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.