/SQL/PS5

PS5

    SELECT
    product_name,
    list_price,
    category_id
FROM
    production.products p1
WHERE
    list_price IN (
        SELECT
            MAX (p2.list_price)
        FROM
            production.products p2
        WHERE
            p2.category_id = p1.category_id
        GROUP BY
            p2.category_id
    )
ORDER BY
    category_id,
    product_name;

Source: sqlservertutorial.net

Ps5

So, your cultured i see.

Ps5

STAY PURE WITH THE PC BOIIII

-1

Similar codes

0 vote336 views1 answer
Python mysql show databases
SQL
0 vote351 views1 answer
Check command
SQL
0 vote339 views1 answer
Insert using condition postgres
SQL
4 votes308 views3 answers
Copy table postgres
SQL
1 vote324 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote306 views1 answer
Nosql vs sql
SQL
5 votes308 views1 answer
Ora-00054 find lock
SQL
0 vote327 views1 answer
Sql change primary key to composite key
SQL
2 votes310 views1 answer
How to get weekday from old date in sql
SQL
0 vote337 views1 answer
Time data type in mysql
SQL