Skip to content

Instantly share code, notes, and snippets.

@geoffb

geoffb/example.sql

Forked from isaacs/example.sql
Created Apr 7, 2010
Embed
What would you like to do?
-- I used to do it like this:
SELECT * FROM table WHERE
hurr
AND (foo = 'bar')
AND (bar = 'foo')
-- Then later I spaced it out even more:
SELECT
*
FROM
table
WHERE
hurr
AND
(foo = 'bar')
LIMIT
1
SELECT *
FROM table
WHERE hurr
AND (foo = 'bar')
AND (bar = 'baz')
LIMIT 1
SELECT a.foo,
a.bar,
a.baz,
b.foo,
b.bar
FROM table_a as a
INNER JOIN table_b as b
ON a.foo = b.foo
WHERE a.bar = 1 AND b.bar = 2
LIMIT 1
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.