/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 vote118 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote94 views1 answer
Output to file mysql
SQL
1 vote108 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote122 views1 answer
How to create a new db from dumb file mysql
SQL
2 votes110 views1 answer
Oracle virtual column
SQL
5 votes142 views2 answers
Functions
SQL
0 vote110 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
8 votes106 views2 answers
Select table column name in sql
SQL
0 vote103 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote104 views1 answer
How to select random rows from table
SQL