Question

Database questions

1. What is the default way a database will order data when using an order by?

2. What SQL syntax do you want to use if you want to order items in "reverse" order?

3. If you wanted to retrieve all results from a table (person) that had your same last name (lname), what would the conditional restriction syntax be?

4. Would you have to use quotes in your conditional statement if your data was classified as numeric?

Answer 1

1. Order by sort the data in ascending order by default

2. To order items in reverse order: ORDER BY COLUMN_NAME DESC;

3. To retrieve all the results with a restriction: SELECT * FROM person WHERE lname = 'specified_last_name_in_query';

4. Quotes are not required in the conditional statement if data was classified as numeric.