Database Query Exercise: Difference between revisions
Jump to navigation
Jump to search
imported>Hendrik Brummermann Created page with "This articles gives you a number of task to solve based on a Stendhal Database. {{TODO|Explain how to get a Stendhal Database}} Some tasks can be solved with one single query, ..." |
imported>Hendrik Brummermann Created page with "This articles gives you a number of task to solve based on a Stendhal Database. {{TODO|Explain how to get a Stendhal Database}} Some tasks can be solved with one single query, ..." |
(No difference)
| |
Revision as of 10:05, 11 September 2011
This articles gives you a number of task to solve based on a Stendhal Database.
TODO: Explain how to get a Stendhal Database
Some tasks can be solved with one single query, other tasks may require a set of queries with human interaction in between. Please point out what to look for in the result set and anything else that should be kept in mind.
If possible explain how the results can be validated.
Example
Get the email address of the account bob:
<source lang="sql"> SELECT email FROM account WHERE username='bob' </source>