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 vote170 views1 answer
Dump only data
SQL
-1 vote262 views5 answers
Left join
SQL
0 vote248 views1 answer
Sqlite display headers on columns
SQL
0 vote163 views2 answers
Update information in a mysql column
SQL
0 vote172 views1 answer
How change the field place in mysql
SQL
0 vote176 views4 answers
How to connect form to database
SQL
3 votes178 views3 answers
How to set up an auto incrementing id db browser
SQL
2 votes196 views2 answers
Mysql does sentence contain word
SQL
0 vote179 views1 answer
Mysql filter based on datediff
SQL
32 votes178 views6 answers
Insert into values select
SQL