Difference between revisions of "SQL Syntax Examples"
From Free Knowledge Base- The DUCK Project: information for everyone
| 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 10: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;
