/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 vote331 views2 answers
Demmarrer un service mysql teminal cmd
SQL
20 votes341 views5 answers
Reset auto increment mysql
SQL
0 vote347 views1 answer
Sql common columns
SQL
12 votes325 views2 answers
Delete entries in postgresql
SQL
1 vote339 views1 answer
Rows to comma separated values in mssql
SQL
0 vote333 views1 answer
Php select data from mysql database without column name
SQL
0 vote366 views1 answer
SQL server datetime compare
SQL
1 vote329 views1 answer
Oracle add proxy
SQL
0 vote346 views1 answer
Multiple replace value mssql
SQL
1 vote352 views1 answer
Setval pgsql
SQL