SQL Syntax Examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 2: | Line 2: | ||
# SELECT * FROM customers; | # SELECT * FROM customers; | ||
# SELECT grade, age, reportcategory FROM students WHERE classroom = 3; | |||
# SELECT username FROM usertable WHERE username like "%icol%"; | # SELECT username FROM usertable WHERE username like "%icol%"; | ||
# DESCRIBE TABLE customer; | # DESCRIBE TABLE customer; | ||
Revision as of 08:38, 1 July 2017
Examples
- SELECT * FROM customers;
- SELECT grade, age, reportcategory FROM students WHERE classroom = 3;
- 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;