Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Code examples for SQL 1x1 blog-article - 09
SELECT
Name,
substr(Name,1,1) AS [Index],
CASE WHEN Milliseconds > 300000 THEN '> 5min.' END AS Länge1,
CASE WHEN Milliseconds > 300000 THEN '> 5min.' ELSE 'kurz' END AS Länge2
FROM Track;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.