/SQL/Sql select maximum column with other columns returned

Sql select maximum column with other columns returned

 with cte as 
 (
     select id, home, date , player, resource, 
     Row_Number()Over(Partition by home order by date desc) rownumber from TestTable
 )
 select id, home, date , player, resource from cte where rownumber=1

Source: stackoverflow.com

Similar codes

0 vote364 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote426 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote383 views1 answer
Postgre query date
SQL
1 vote380 views1 answer
Convert epoch to date in sql server
SQL
0 vote374 views1 answer
T-sql email validation
SQL
1 vote444 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote372 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote350 views1 answer
Sql select first and last record of each group
SQL
13 votes341 views4 answers
Mysql get last row
SQL
4 votes352 views2 answers
Sql table
SQL