Access Query

0

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”

Share.

About Author

Comments are closed.

Please note we do not accept any responsibility for errors occurring During Use of this site users follow instructions listed at their own risk.