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 vote166 views1 answer
Can we rollback deleted data in sql
SQL
5 votes144 views1 answer
Mongodb vs
SQL
0 vote186 views1 answer
PostgreSQL types and C# types
SQL
0 vote171 views1 answer
Components/Fields of Internal Table
SQL
0 vote166 views1 answer
Mssql current date
SQL
1 vote158 views1 answer
Mysql order by desc null last
SQL
25 votes177 views4 answers
Sqlserver add column
SQL
35 votes188 views5 answers
Sql alter column
SQL
1 vote171 views1 answer
Postgres set column equal to another
SQL
0 vote167 views1 answer
Get id if is not equal in certain table
SQL