Record count for distinct records

Results 1 to 2 of 2

Thread: Record count for distinct records

  1. #1
    Tony Guest

    Default Record count for distinct records

    Hi again.. <BR>i guess for my past post i didn&#039t made any sence so i found a site to show you what i am looking for and choose something from sport & outdoor dropdown . the distinct categories are represented by a number right beside them and that represents number of products for given distinct category or whatever is.. i was wondring how i can do that.. ? i can write distinct categories on my web page but i need to show the numbers as well. i hope i am making some sence now..<BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Record count for distinct records

    SELECT CategoryName, Count(*) FROM ItemsTable<BR>GROUP BY CategoryName<BR>SORT BY CategoryName<BR><BR>That&#039s not the best way to do it, because you don&#039t really want the CategoryName repeated in each item, but exactly how you do it past here depends on the organization of your DB.<BR><BR>

Posting Permissions

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