Endermanbugzjfc/confusion.sql

Last active September 11, 2023 10:04

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Endermanbugzjfc/0c8e3b4b1024d2cacc6f1e87c6bd319c.js"></script>
Save Endermanbugzjfc/0c8e3b4b1024d2cacc6f1e87c6bd319c to your computer and use it in GitHub Desktop.

Download ZIP

Hint: some general programming ideas are applied on here. Ask yourself: why is the * 2 + used on booleans instead of numbers.

Raw

confusion.sql

	SELECT * FROM Customers
	WHERE uuid = "weqsc" OR wtfid = "weqsc"
	ORDER BY (uuid IS NOT NULL) * 2 + (wtfid IS NOT NULL) DESC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment