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 vote147 views1 answer
Mysql insert multiple rows based on select
SQL
7 votes146 views1 answer
Sql pagination oracle
SQL
0 vote142 views1 answer
Sql value exists in column
SQL
1 vote141 views1 answer
Mysql sort by date column
SQL
0 vote144 views1 answer
Where date in datetime mysql
SQL
12 votes132 views4 answers
Mysql ifnull
SQL
0 vote132 views1 answer
Postgresql update to unique
SQL
0 vote140 views1 answer
Php mysqli install
SQL
0 vote150 views1 answer
Psql check table fields
SQL
11 votes133 views2 answers
Oracle all source
SQL