/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 vote352 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote327 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
11 votes377 views2 answers
Oracle source code
SQL
2 votes358 views4 answers
Check timezone of mysql database
SQL
0 vote330 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote337 views1 answer
Selecting Data in SQL - Select Data
SQL
14 votes357 views1 answer
Excel
SQL
0 vote384 views1 answer
Write SQL in ruby on rails
SQL
11 votes378 views1 answer
Oracle export view ddl
SQL
0 vote360 views1 answer
How to write if case in select query in select statement
SQL