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 vote254 views1 answer
Redshift running queries
SQL
0 vote197 views1 answer
Cannot start database server xampp mac os
SQL
2 votes216 views2 answers
Spring import sql
SQL
1 vote213 views1 answer
Table infromation in sql server
SQL
21 votes215 views6 answers
Update sql
SQL
0 vote211 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote211 views1 answer
Liquibase update row
SQL
1 vote230 views1 answer
Mysql check if string contains comma separated
SQL
0 vote229 views1 answer
How to get button for every record from mysql
SQL
0 vote200 views1 answer
How get data from database if id not found then search another column
SQL