/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

16 votes109 views3 answers
Jwt secret key generator laravel
SQL
0 vote120 views1 answer
Is not numeric sql
SQL
15 votes111 views6 answers
Laravel db transaction
SQL
0 vote99 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote99 views1 answer
Ignore case in string sql
SQL
5 votes113 views4 answers
Change auto increment mysql
SQL
1 vote70 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote84 views1 answer
Sql menampilkan data tabel
SQL
2 votes91 views2 answers
How to get capital letter first in sql
SQL
1 vote107 views1 answer
Oracle grant on all tables in schema
SQL