/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

1 vote364 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote329 views1 answer
Replace sqlalchemy
SQL
2 votes348 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote330 views1 answer
Sql server whoami
SQL
0 vote406 views1 answer
Mysql backup query
SQL
0 vote337 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote378 views1 answer
Pgadmin check database
SQL
0 vote353 views1 answer
Create a table from one field of another table
SQL
13 votes334 views4 answers
Mysql select last 10 rows
SQL
8 votes364 views1 answer
How to check mysql version in xampp
SQL