[MySQL] How to fetch only 10 results from "SELECT"

Oracle, MS-SQL, and MySQL differs slightly. Here is the MySQL version. 
Just add "LIMIT" after selection statement. 

     SELECT nIdx 
        FROM tb_table 
ORDER BY time DESC 
        LIMIT 10;