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 vote340 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote333 views1 answer
Cannot start database server xampp mac os
SQL
0 vote356 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
1 vote311 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote334 views1 answer
Less mysql display
SQL
0 vote347 views1 answer
Sql how to get courses that i have made prerequisites
SQL
1 vote343 views1 answer
Myql find duplicates
SQL
0 vote305 views1 answer
Mysql max number not returning correct value
SQL
2 votes327 views1 answer
Mariadb JSON_EXTRACT
SQL
5 votes309 views2 answers
Oracle tables with column name
SQL