Writing a Basic Query
Sheila wants to see the data in the HR tables. She would like to view the data in the EMPLOYEES and DEPARTMENTS tables.
Watch Sheila retrieve data from the DEPARTMENTS and EMPLOYEES tables:
 |
Show Me and Try It: Use SQL Workshop to see the DEPARTMENTS table data |
|
Show Me and Try It: Watch Sheila use Query Builder to see the EMPLOYEES table data |
Now that Sheila can see the data, she wants to sort it. She would like to see the data in the EMPLOYEES table sorted by last names.
|
Show Me and Try It: Use SQL Workshop to see the EMPLOYEES table data sorted |
|
Show Me and Try It: Watch Sheila use Query Builder to see the EMPLOYEES table data sorted |