Difference between revisions of "Select Queries"
| Line 5: | Line 5: | ||
<syntaxhighlight lang=sql> | <syntaxhighlight lang=sql> | ||
| − | + | SELECT `data` FROM `TABLE` | |
| − | + | 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 ;
