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

3 votes112 views3 answers
Postgresql random number
SQL
0 vote105 views1 answer
Postgresql delete type
SQL
2 votes107 views1 answer
Get hour from date sql
SQL
1 vote121 views1 answer
Snowflake rename column name
SQL
1 vote103 views1 answer
Regular expression in sql server
SQL
0 vote113 views1 answer
Drush run sql select
SQL
1 vote108 views3 answers
Sql select only time from datetime
SQL
0 vote105 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote114 views1 answer
Drop view in mysql
SQL
0 vote100 views1 answer
Database db connection string format
SQL