Horje
coursera spark sql max count Code Example
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
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



Sql

Related
new uniqueidentifier in sql Code Example new uniqueidentifier in sql Code Example
john the ripper mysql Code Example john the ripper mysql Code Example
mysql row generator Code Example mysql row generator Code Example
delete ids between sql Code Example delete ids between sql Code Example
check if two date ranges overlap sql server Code Example check if two date ranges overlap sql server Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje