/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

3 votes126 views1 answer
Sql select all
SQL
0 vote129 views1 answer
How to Remove milliseconds from Date time
SQL
7 votes128 views3 answers
How ot change name of column mysql
SQL
-1 vote137 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote143 views1 answer
Oracle select partition
SQL
1 vote154 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote129 views1 answer
Find largest table in mysql database
SQL
0 vote142 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote133 views1 answer
Authentication in sql server
SQL
0 vote143 views1 answer
Hour and minute between two datatime sql
SQL