SQL basics

Question 1

What does SELECT do?

Answer 1

The feilds that you want the query to return/display data from

Question 2

What does FROM do?

Answer 2

Specify the names of the tables where the data is to be retrieved from

Question 3

What does WHERE do?

Answer 3

Enter your search criteria which the returned recods have to match

Question 4

What does ORDER BY do?

Answer 4

Enter the field name that you want to order the results by the end in what order (ASC/DESC)