Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Exercise idea: latest unique key value #180

Open
d6y opened this issue Nov 28, 2019 · 1 comment
Open

Exercise idea: latest unique key value #180

d6y opened this issue Nov 28, 2019 · 1 comment
Labels
Chapter 6: Joins & Agregates

Comments

@d6y
Copy link
Contributor

d6y commented Nov 28, 2019

Given:

key value timestamp
a 1 mon
b 2 wed
b 3 thu

Select the latest (largest timestamp) for each key.

I.e., find (a-> 1), and (b ->3)
@d6y
Copy link
Contributor Author

d6y commented Nov 28, 2019

Relates to: #114

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Chapter 6: Joins & Agregates
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@d6y