Why this MySQL query wont work

Question

select p_product 
from (select p_product, count(p_product) 
      from rental 
      group by p_product 
      order by count(p_product) desc LIMIT 5);

Error: Every derived table must have its own alias

All you had to do was put the error message into SO's search field to find the answer. — Barmar, Mar 03 '17 at 19:29

score 1 · Answer 1 · answered Mar 03 '17 at 19:20

1

Add an alias to the subquery:

select p_product
from (
    select p_product,
        count(p_product)
    from rental
    group by p_product
    order by count(p_product) desc LIMIT 5
    ) t;
------^ here

Also, you dont really need a subquery:

select p_product
from rental
group by p_product
order by count(p_product) desc LIMIT 5

answered Mar 03 '17 at 19:20

Gurwinder Singh

38,557
6
51
76

Exactly, I dont need a subquery for this. I was just checking how it works with an example. Thanks. – Manpreet Mar 03 '17 at 19:25

Why this MySQL query wont work

1 Answers1