/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

11 votes217 views2 answers
Set default column value sql
SQL
5 votes272 views4 answers
Restart the psql server windows
SQL
3 votes187 views4 answers
Ubuntu stop mysql
SQL
0 vote188 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote189 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote244 views1 answer
Tsql cte in a transaction
SQL
24 votes190 views5 answers
Sql reset auto increment
SQL
8 votes200 views2 answers
Update sql server from another table
SQL
1 vote174 views1 answer
Launch sql script from docker in mysql
SQL
0 vote188 views1 answer
Mysql grant all on all databases
SQL