Coursera spark sql max count

+-----------+----------+----------+
|color      |      date|max(count)|
+-----------+----------+----------+
|        red|2014-05-26|         5|
|       blue|2014-05-26|         3|
|      brown|2014-07-31|         2|
|      green|2014-08-01|         2|
+-----------+----------+----------+

Source: stackoverflow.com

Coursera spark sql max count

df.groupBy(color).max("count").show();

+-----------+----------+
|color      |max(count)|
+-----------+----------+
|        red|         5|
|       blue|         3|
|      brown|         2|
|      green|         2|
+-----------+----------+

Source: stackoverflow.com

Similar codes

0 vote319 views1 answer
Tsql cte in a transaction
SQL
0 vote325 views1 answer
Mysql streaming example
SQL
1 vote279 views1 answer
Oracle apex version view
SQL
0 vote263 views1 answer
Sql row number in result set
SQL
10 votes273 views1 answer
Oracle all_dependencies
SQL
1 vote287 views1 answer
Create new index takes long time postgresql
SQL
6 votes282 views2 answers
Mysql interval 1 day
SQL
0 vote272 views1 answer
Sql #region
SQL
0 vote304 views1 answer
Insert into table with only identity column
SQL
0 vote299 views1 answer
Having all mysql
SQL