Difference between revisions of "Help:Sandbox"
From SDU
| Line 1: | Line 1: | ||
Feel free to try out the wiki syntax in this page.<br> | Feel free to try out the wiki syntax in this page.<br> | ||
<!-- test your skills below this line --> | <!-- test your skills below this line --> | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | Here is the query you would use to retrieve all Service Desk contacts with the last name "Smith" : | ||
| + | <source lang="sql"> | ||
| + | SELECT * | ||
| + | FROM ca_contact | ||
| + | WHERE last_name = 'Smith' | ||
| + | </source> | ||
| + | |||
| + | <source lang="sql" line> | ||
| + | SELECT * | ||
| + | FROM ca_contact | ||
| + | WHERE last_name = 'Smith' | ||
| + | </source> | ||
Revision as of 05:07, 24 January 2008
Feel free to try out the wiki syntax in this page.
Here is the query you would use to retrieve all Service Desk contacts with the last name "Smith" :
<source lang="sql">
SELECT *
FROM ca_contact
WHERE last_name = 'Smith'
</source>
<source lang="sql" line> SELECT * FROM ca_contact WHERE last_name = 'Smith' </source>