/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 vote280 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote275 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote286 views1 answer
Xampp increame mysql speed
SQL
7 votes300 views1 answer
Mysql iif
SQL
0 vote375 views1 answer
Sqlite display data in separated columns
SQL
0 vote278 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote296 views1 answer
Authentication in sql server
SQL
0 vote283 views1 answer
Varchar format not case sensitive sql
SQL
3 votes313 views2 answers
Oracle sql first day of month
SQL
1 vote289 views1 answer
Tsql find foreign key references
SQL