SQL basics Flashcards
(4 cards)
What does SELECT do?
The feilds that you want the query to return/display data from
What does FROM do?
Specify the names of the tables where the data is to be retrieved from
What does WHERE do?
Enter your search criteria which the returned recods have to match
What does ORDER BY do?
Enter the field name that you want to order the results by the end in what order (ASC/DESC)