How to show 10% of all the records using mysql

Question

I want to show only 15% of all records using mysql, all I see is a way to show only a specific number of rows. Is there a way to do such thing.

Thanks in advance.

Try to maintain a degree of consistency here. Ten? Fifteen? – tadman Jun 04 '16 at 17:43 — tadman, Jun 04 '16 at 17:43

score 1 · Answer 1 · edited May 23 '17 at 12:22

1

You probably need to calculate it by yourself like

declare var int;    
select var = (count(*) * .15) from mytable;

select * from mytable
order by id
limit 1, var;

You can also use SQL_SELECT_LIMIT option like below. Got from this thread Variable LIMIT Clause in MySQL

Set SQL_SELECT_LIMIT = var;

select * from mytable
order by id;

edited May 23 '17 at 12:22

Community

answered Jun 04 '16 at 17:14

Rahul

replace `=` with `:=` ... – stack Jun 04 '16 at 17:19
@stack, it's a declared variable and so not needed. – Rahul Jun 04 '16 at 17:20
Ah I see ...... Just why `.15`? OP said `10%` – stack Jun 04 '16 at 17:21
@stack, read the question again; it says *I want to show only 15% ...* – Rahul Jun 04 '16 at 17:23

1 Answers1