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 vote183 views2 answers
How to add CHECK constraint to a column in postgres
SQL
17 votes183 views5 answers
Order by sql
SQL
0 vote199 views1 answer
Oracle list user locked
SQL
0 vote169 views1 answer
Sql server remove 0 from left
SQL
0 vote182 views1 answer
Format the money fied with comma in international system using sql
SQL
4 votes167 views2 answers
How to count items with same name in sql
SQL
4 votes204 views6 answers
Select sql
SQL
0 vote169 views1 answer
Search mysql database for column
SQL
2 votes161 views1 answer
Sql like variable
SQL
2 votes179 views1 answer
Capitalize 1st letter in sql server
SQL