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

6 votes396 views2 answers
Mysql convert timestamp to date
SQL
0 vote377 views1 answer
Sqlcmd no headers
SQL
0 vote366 views2 answers
Imageview setimageresource null
SQL
0 vote351 views1 answer
Complete date is 1 year or not sql server
SQL
1 vote404 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote377 views1 answer
Mysql get date diff in months
SQL
3 votes371 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote379 views1 answer
Mysql 1 hour ago
SQL
8 votes357 views2 answers
Change name of colum in sql table
SQL
9 votes342 views2 answers
Get first 3 letters in sql
SQL