How to use 'limit' in combination of 'order by'? 1

[lcs01]

I want to write a sql like this:

select * from mytable limit 10 order by pid

I know the above sql has a syntax error, i.e. you can not use 'limit' together with 'order by'. But, is there a way to perform this kind of task?

Many thanks!

 

[TonyGroves]

Put the "limit" after the "order by".