/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 vote242 views1 answer
T-sql disable system versioning
SQL
0 vote250 views1 answer
Mysql milliseconds
SQL
0 vote235 views1 answer
Sql anywhere create procedure
SQL
0 vote230 views1 answer
Sql find leading space
SQL
0 vote232 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote237 views1 answer
Mysql error 1251
SQL
17 votes247 views4 answers
Sort by mysql
SQL
36 votes235 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote297 views1 answer
Drop view sql
SQL
-1 vote237 views1 answer
Mysql #1064 error
SQL