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