Search results

  1. L

    Select Count using Min Aggregate function

    Thanks! I may have forgot to say that this must be for a specific Item so I would have to leave it as SELECT TOP 1 tPrice.Price, Count(tPrice.Price) AS CountOfPrice FROM tPrice Where Item = @Item GROUP BY tPrice.Price ORDER BY tPrice.Price; Cheers!
  2. L

    Select Count using Min Aggregate function

    Hi Guys... I am new to Microsoft Access and am primarily using the database that talks to an SQL database that I am using in a C#/ASP environment. Currently I am trying to create a query that would find the minimum price in a table however, I also want to count the amount of times that the...
Back
Top Bottom