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 vote188 views1 answer
Sql drop default
SQL
0 vote223 views1 answer
Mysql get nested records
SQL
1 vote199 views1 answer
Psql autocomplete for mac brew install
SQL
1 vote193 views1 answer
Oracle apex version view
SQL
0 vote190 views1 answer
Setval postgres example table id
SQL
2 votes189 views1 answer
Codeigniter print last sql query
SQL
0 vote185 views1 answer
How to install Firebird
SQL
3 votes190 views3 answers
Stop mysql ubuntu
SQL
2 votes222 views1 answer
Capitalize 1st letter in sql server
SQL
0 vote202 views1 answer
Ignore case in string sql
SQL