Show Me Glossary
 

Writing a Basic Query

Previous previous|next Next Page

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...

Launch Demonstration

Show Me and Try It! - Use SQL Workshop to see the DEPARTMENTS table data

Launch Demonstration

Show Me! - 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 their last names.

Launch Demonstration

Show Me and Try It! - Use SQL Workshop to see the EMPLOYEES table data sorted

Launch Demonstration

Show Me! - Watch Sheila use Query Builder to see the EMPLOYEES table data sorted