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 vote140 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote189 views1 answer
Alternative for LIMIT sql
SQL
0 vote141 views1 answer
Hive batch drop table
SQL
0 vote130 views1 answer
Remove from table where
SQL
2 votes183 views1 answer
Creating a view SQL
SQL
0 vote152 views2 answers
Dbms interview questions
SQL
1 vote148 views1 answer
Set statiscis on in ssms
SQL
0 vote136 views1 answer
Groupby error in mysql
SQL
1 vote127 views1 answer
Sql alchemy with azuresql server
SQL
6 votes149 views3 answers
What is where in sql
SQL