CODEWITHSUNDEEP
asp-classic
daisy
daisy

Reputation:

Count certain record in database

How can I count the number of certain records in database using classic asp? For example, I want to count how many record are there for Car..I'm using ms access. need help. thank you.

Upvotes: 0

Views: 228

Answers (2)

recursive
recursive

Reputation: 86174

Yes.

SELECT COUNT(*) FROM Table WHERE Field = 'Car'

Upvotes: 1

marcc
marcc

Reputation: 12409

Is car a table?

select count(1) from car

Just like any other query.

Upvotes: 0

Related Questions