MySQL find data from small to large ranked 90th position

Method One (stored procedure implementation):

Begin
DECLARE cnt INT DEFAULT 0;
Select COUNT (*) into CNT from user;
Set cnt = Round (cnt*0.9)-1;
SELECT * from user limit CNT, 1;
End

Method two (direct query, only when the query permissions can be considered):

This approach also solves the problem of not supporting variables behind MySQL limit

SELECT COUNT (*) into @cnt from cmb_loading_count_20141013 WHERE ver>=1003002251;
SET @cnt = ROUND (@cnt *0.9)-1;
SET @stmt = ' Select Loading_time from cmb_loading_count_20141013 where ver>=1003002251 ORDER by loading_time ASC limit ?,?‘;
PREPARE S1 from @stmt;
SET @end = 1;
EXECUTE S1 USING @cnt, @end;
deallocate PREPARE S1;

Reference:

Http://www.2cto.com/database/201309/241093.html

MySQL find data from small to large ranked 90th position