Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Phoenix ,AZ
    Posts
    2

    Red face Unanswered: counting records in a query

    I have been tring to count a records in a query.
    I have 32 different modes for fall out for 10 different products
    I need to count the top 5 fall out catagorys for each product in decending order

    I have the chart displaying all catagories but need only the top 5

    Rich L

  2. #2
    Join Date
    Dec 2003
    Posts
    10

    Re: counting records in a query

    There's an SQL function called LIMIT.... Try playing around with that one.
    - Morty

  3. #3
    Join Date
    Jan 2004
    Location
    Romania - Bucharest
    Posts
    50
    select top 5 * from ( select ... from ... order by desc)

  4. #4
    Join Date
    Jan 2004
    Location
    Phoenix ,AZ
    Posts
    2

    counting records in a query

    Originally posted by marp
    select top 5 * from ( select ... from ... order by desc)
    I tried that and it only gives me the top 5 for the first product not the top five of each product.

Posting Permissions

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