/SQL/Sql server select record with max id

Sql server select record with max id

select ID , ProductCatId , ProductCode , Price
  from (
        select ID , ProductCatId , ProductCode , Price, row_number() over (partition by ProductCatId order by ID desc) as rn
         from myTable
        ) as t
  where t.rn = 1

Source: stackoverflow.com

Similar codes

1 vote163 views1 answer
Mysql update inner
SQL
-1 vote148 views3 answers
My sql alter table
SQL
-1 vote134 views1 answer
Round up and down sql
SQL
1 vote143 views1 answer
Oracle apex prevent initial load
SQL
6 votes169 views1 answer
To count number of rows in SQL table
SQL
4 votes147 views3 answers
How to describe a table in sqlite3
SQL
0 vote131 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
-1 vote166 views1 answer
Mysql coalesce
SQL
0 vote164 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
1 vote146 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL