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 vote142 views1 answer
Play framework connection via windows sql server
SQL
0 vote115 views1 answer
Sintaxis SELECT sql
SQL
0 vote113 views1 answer
Run postgresql dump to csv
SQL
2 votes111 views1 answer
Postgresql add entry to table
SQL
2 votes120 views1 answer
How to find constraints on a table in oracle
SQL
0 vote159 views1 answer
Sql check if field is not null
SQL
1 vote111 views1 answer
Set mysql mode global query
SQL
2 votes157 views3 answers
How to replace null values in sql
SQL
15 votes109 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote127 views2 answers
Generate sql trigger through ef migration
SQL