PoTHuYJoHN/gist:6022244

Last active December 19, 2015 21:48

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/PoTHuYJoHN/6022244.js"></script>
Save PoTHuYJoHN/6022244 to your computer and use it in GitHub Desktop.

Download ZIP

Get elements from the same table where parent_id does not exists

Raw

gistfile1.sql

SELECT * FROM help as t1 left JOIN help as t2 ON t1.parent_id = t2.id WHERE t2.id IS NULL AND t1.isCategory = 1

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