/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 votes284 views1 answer
Sql query to find duplicates in column
SQL
0 vote287 views1 answer
Mysql 1 hour ago
SQL
3 votes283 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
1 vote278 views4 answers
Mysqldump 1 table only
SQL
0 vote226 views1 answer
Mysql select top 2
SQL
18 votes279 views3 answers
Mysql add column with default value
SQL
3 votes285 views2 answers
Sql asc
SQL
0 vote286 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote311 views2 answers
What is rownum in oracle
SQL
-1 vote292 views8 answers
Create Trigger in phpMyAdmin
SQL