/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

4 votes287 views1 answer
Sql query to make a existing column auto increment
SQL
2 votes313 views3 answers
Sql server reseed identity column
SQL
1 vote374 views2 answers
Coderbyte sql solutions
SQL
1 vote284 views1 answer
Return size of tables in mysql
SQL
10 votes250 views1 answer
Oracle view dependencies
SQL
1 vote300 views2 answers
Copy database mysql
SQL
0 vote281 views2 answers
Show slave status mysql
SQL
7 votes293 views3 answers
Restore postgres database from sql file
SQL
1 vote286 views1 answer
Mysql select update same table
SQL
0 vote274 views1 answer
Zsh: command not found: mysql mamp
SQL