Searching Data

Question 1

What is SQL

Answer 1

Structured Query Language

Question 2

What can SQL be used for?

Answer 2

To search tables in a database for specific data

Question 3

Order of keywords

Answer 3

‘SELECT’ fieldname ‘FROM’ nameoftable

Question 4

What is ‘WHERE’ used for?

Answer 4

To specify conditions that a record must satisfy before it is returned

WHERE can be followed with Boolean operators to make the search more specific