/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 vote267 views1 answer
Add multiple field in table sql
SQL
2 votes297 views1 answer
Datefromparts mssql
SQL
0 vote296 views2 answers
Suse Linux restart MySQL
SQL
0 vote270 views1 answer
Sql query use select name inside where clause
SQL
0 vote263 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote289 views2 answers
This month mysql where
SQL
1 vote268 views1 answer
Mysql breakline on string
SQL
1 vote262 views1 answer
Data type and their numeric form
SQL
0 vote249 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote265 views1 answer
Mysql bind-address default value
SQL