Now we have a table created we can start to use it
I want to know which customer has the account_no 99999999
The SQL Query would look like this
Select * from Customers
where account_no = 99999999
If the account_no field was not a number but a text field (varchar)
the 99999999 would have to be enclosed in quotes “99999999” you can normally use single or double quotes in any database:-
Select * from Customers
where account_no = “99999999”
