/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 vote139 views1 answer
IS THEre any difference between using default and := in plsql
SQL
15 votes129 views6 answers
Psql
SQL
0 vote153 views1 answer
Mysql last friday of current month
SQL
1 vote123 views1 answer
Pl sql ptint
SQL
0 vote127 views1 answer
Get record which is available in one table but not in another mysql
SQL
2 votes115 views2 answers
Compare date mysql
SQL
0 vote125 views1 answer
Oracle string length
SQL
1 vote131 views1 answer
Error code 1292 mysql workbench
SQL
0 vote130 views1 answer
How to query all tables mysql at the same time
SQL
8 votes118 views2 answers
Mysql query dates between two dates
SQL