Re: Limit inclouding also all the equals with the last row

[Kostas Konstantinidis]

Dear Peter,
trying your last suggestion

select a.person, a.countofid_films as N
from temp a
join (
select distinct countofid_films
from temp
order by countofid_films desc
limit 10
) b using( countofid_films);
order by N desc;

it returns
ERROR 1349: View's SELECT contains a subquery in the FROM clause

thank's