Explain the use of where clause in ms access sql?



Explain the use of where clause in ms access sql?..

Answer / Surash Shing

The WHERE clause is used in MS Access SQL to filter records based on specified conditions. For example: SELECT * FROM Customers WHERE Country = 'USA'. This query retrieves all columns from the Customers table where the Country field is equal to 'USA'.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Access Interview Questions

what is the 4 types of validation

2 Answers  


How do I create a small business database in access?

1 Answers  


How long does it take to learn ms access?

1 Answers  


What format should my database be saved in to allow different versions of Microsoft Access to open the database?

1 Answers  


What can I use microsoft access for?

1 Answers  


How would you manager data tasks?

1 Answers  


How many types of relationships are there in ms access?

1 Answers  


What is the difference between excel and access?

1 Answers  


Can you copy and paste from excel to access?

1 Answers  


Explain how you can build a relationship between the different databases in access?

1 Answers  


Is ms access still used?

1 Answers  


Is there a limitation on the size of a database that can be opened in microsoft access?if yes, what?

1 Answers  


Categories