/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 vote125 views1 answer
Como hacer una consulta en sql
SQL
0 vote125 views1 answer
Mysql change innodb to myisam
SQL
0 vote124 views1 answer
Sql last 3 rows
SQL
1 vote113 views1 answer
Set all the vluses in calumn in sql to false
SQL
3 votes158 views1 answer
Oracle nextval insert
SQL
1 vote130 views2 answers
Find nth highest salary of an employee
SQL
1 vote117 views2 answers
How to enable error squiggles in vs code
SQL
1 vote120 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote136 views1 answer
Sql field equals multiple values
SQL
1 vote123 views1 answer
Name of today sql
SQL