/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

15 votes269 views4 answers
Export mysql db using command line
SQL
0 vote219 views1 answer
Mysql show create db
SQL
0 vote278 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
28 votes199 views6 answers
Mysql change user password
SQL
0 vote185 views1 answer
Difference between cross apply and inner join
SQL
0 vote209 views1 answer
Recently updated stored procedure in sql server
SQL
15 votes197 views2 answers
How to drop database name in postgresql
SQL
0 vote191 views2 answers
Sql use not in
SQL
13 votes208 views3 answers
Uninstall mysql centos 7
SQL
1 vote193 views1 answer
Round function in sql oracle
SQL