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

2 votes161 views1 answer
Revokeprivileges mysql
SQL
1 vote127 views1 answer
Round function in sql oracle
SQL
3 votes163 views3 answers
Sql current year
SQL
1 vote150 views1 answer
Sql drop schema
SQL
0 vote140 views1 answer
Why mysql is used?
SQL
0 vote213 views1 answer
Sql if clause within where clause
SQL
6 votes130 views1 answer
Wordpress change user password sql
SQL
0 vote159 views1 answer
Mysql config slave
SQL
0 vote129 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote200 views2 answers
Wordpress change url in database
SQL