how to get first 50% records from a table mysql code example

Example: how to get first 10 records of a table in mysql

SELECT *FROM yourTableName ORDER BY yourIdColumnName LIMIT 10;