SQL Syntax Examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
# SELECT * FROM customers; | # SELECT * FROM customers; | ||
# SELECT username FROM usertable WHERE username like " | # SELECT username FROM usertable WHERE username like "%icol%"; | ||
# DESCRIBE TABLE customer; | |||
# SELECT usertable.UserName, Posts.PostID FROM usertable LEFT JOIN Posts ON usertable.UserID = Posts.UserID ORDER BY usertable.UserName; | |||
== Other Pages with SQL Examples == | == Other Pages with SQL Examples == | ||
Revision as of 08:35, 1 July 2017
Examples
- SELECT * FROM customers;
- SELECT username FROM usertable WHERE username like "%icol%";
- DESCRIBE TABLE customer;
- SELECT usertable.UserName, Posts.PostID FROM usertable LEFT JOIN Posts ON usertable.UserID = Posts.UserID ORDER BY usertable.UserName;