Difference between revisions of "Select Queries"
| Line 7: | Line 7: | ||
SELECT `data` FROM `TABLE` | SELECT `data` FROM `TABLE` | ||
WHERE `Condtion` | WHERE `Condtion` | ||
| − | + | ORDER BY `TABLE` ASC / DESC ; | |
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 15:44, 15 December 2016
- Used for fetching information from an SQL database.
- 'Outputs' the data once successfully selected
- Allows selection from multiple tables but not multiple databases.
SELECT `data` FROM `TABLE`
WHERE `Condtion`
ORDER BY `TABLE` ASC / DESC ;
