/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

3 votes328 views4 answers
Stop MySQL
SQL
1 vote321 views3 answers
How to truncate foreign key constraint table
SQL
0 vote316 views1 answer
Mysql show create db
SQL
0 vote318 views1 answer
Search In the Data using ObjectName
SQL
0 vote348 views4 answers
Convert databse to achieve log mode oracle
SQL
5 votes336 views3 answers
Bash: mysql: command not found
SQL
0 vote346 views1 answer
Error code 1241 mysql
SQL
3 votes320 views1 answer
Select table column in sql
SQL
1 vote312 views1 answer
Count of tables in database mysql
SQL
3 votes361 views3 answers
Mysql auto increment after delete
SQL