Hi I have a SQL database & I want to return

Question

Hi I have a SQL database & I want to return

10 highest values in each category, how can I do this for each category?
already wrote this query:

SELECT * FROM products ORDER BY category, price DESC
LIMIT 10

but this only returns highest prices from just one category, I want to return 10 for every category...

0

16.09.2021

4 ответов

10 просмотров

ＡλＩ Автор вопроса

can someone answer this please

0

17.09.2021

Paresh Wadhwani

you can use rank()

0

17.09.2021

ＡλＩ Автор вопроса

Paresh Wadhwani
you can use rank()

thanks I'm working with the database on Colab (pandas.read_sql_query), rank() syntax gives error I don't know why. I've write this query and it works fine but how can I get 10 rows for each unique category_id? SELECT product_id, category_id, price FROM products WHERE ( SELECT COUNT(*) FROM products ORDER BY category_id ASC, price DESC )

0

17.09.2021

A X · Accepted Answer

A X

First group by category then order by price.

0

17.09.2021

Похожие чаты

Hi I have a SQL database & I want to return

4 ответов

Похожие вопросы