mysql top 3 records by a field code example

Example: mysql command line top 10

mysql> select *from DemoTable limit 0,10;