/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 vote230 views2 answers
PostgreSQL having
SQL
16 votes204 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote221 views1 answer
Str_to_date sql server
SQL
-1 vote203 views1 answer
Sql oracle take only last results
SQL
1 vote206 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
5 votes193 views1 answer
Ora-00054 find lock
SQL
0 vote212 views1 answer
Mysql drop vs delete
SQL
0 vote238 views1 answer
Find wordpress version in database
SQL
0 vote212 views1 answer
Recently updated stored procedure in sql server
SQL
3 votes197 views2 answers
Update Query in SQL Server
SQL