Skip to content

Instantly share code, notes, and snippets.

@hellofromtonya

hellofromtonya/alias.sql Secret

Created October 11, 2016 20:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hellofromtonya/c3f68f4539515d3a195748dcf4f99f0a to your computer and use it in GitHub Desktop.
Save hellofromtonya/c3f68f4539515d3a195748dcf4f99f0a to your computer and use it in GitHub Desktop.
Download ZIP
Table Alias with AS in SQL
Raw
alias.sql
SELECT posts.ID, posts.post_title
FROM wp_posts AS posts
WHERE posts.post_type = 'post' AND posts.post_status = 'publish';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment