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 vote333 views1 answer
How to to get time in sql
SQL
-1 vote346 views3 answers
My sql alter table
SQL
0 vote330 views1 answer
Power bi find all ids not in other tables
SQL
1 vote346 views1 answer
Mysql curdate between two dates
SQL
6 votes363 views4 answers
Mysql group by month
SQL
0 vote333 views1 answer
Sql query to find duplicate email address
SQL
1 vote378 views1 answer
Opensuse restart MySQL
SQL
11 votes345 views4 answers
MYSQL LOGIN
SQL
0 vote304 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote310 views1 answer
Update table sql multiple set
SQL