LCDUNG.

#MySQL
SELECT column_name FROM table_name ORDER BY column_name ASC LIMIT 10; 
#SQL Server 
SELECT TOP 10 column_name FROM table_name ORDER BY column_name ASC;