Count SQL statement

Results 1 to 2 of 2

Thread: Count SQL statement

  1. #1
    Join Date
    Dec 1969

    Default Count SQL statement

    Hi I have 8 items that I want to count. For example Pens, Pencils etc. If I run the following SQL <BR><BR>Select Count(*) Where Object_Name = &#039;Pencil&#039; It runs and gives me a count of Pencils. But what I want to do is run the SQL once for all eight items. Is it possible?<BR><BR>Thanks in advance for help.

  2. #2
    Join Date
    Dec 1969

    Default ...

    SELECT object_name, COUNT(*) FROM tablename GROUP BY object_name<BR><BR><BR>HTH<BR><BR>Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts