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

Ability to sort with nulls last #198

Open
simonw opened this issue Apr 9, 2018 · 0 comments
Open

Ability to sort with nulls last #198

simonw opened this issue Apr 9, 2018 · 0 comments
Labels
feature

Comments

@simonw
Copy link
Owner

simonw commented Apr 9, 2018

Split off from #189

Here's how to do that in SQL: https://fivethirtyeight.datasettes.com/fivethirtyeight-2628db9?sql=select+rowid%2C+*+from+%5Bnfl-wide-receivers%2Fadvanced-historical%5D%0D%0Aorder+by+case+when+career_ranypa+is+null+then+1+else+0+end%2C+career_ranypa%2C+rowid

order by case when career_ranypa is null then 1 else 0 end, career_ranypa
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@simonw