/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

5 votes280 views3 answers
Postgres show databases
SQL
38 votes348 views6 answers
Ubuntu install mysql client
SQL
2 votes260 views1 answer
How to add where command in update comand with joins
SQL
0 vote273 views1 answer
Flexible search query delete table
SQL
0 vote269 views1 answer
Mysql master slave setup with keepalived
SQL
8 votes305 views1 answer
Mysql dump restore
SQL
0 vote260 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote379 views1 answer
Sql insert exemplo
SQL
0 vote275 views1 answer
Sql find record cannot cast date
SQL
0 vote282 views1 answer
How to find lowest in sql
SQL