Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: paulostrom
  • Content: Threads
  • Order by date
  1. paulostrom

    Top 3 Query Problem

    A while back (thread232-1437399)I needed help with a query that would return the highest 3 daily sales amounts from multiple locations. r937 pointed me in the right direction with this query: select location , Daily_Sales from Sales as T where ( select count(*) from Sales...
  2. paulostrom

    Limiting Query Results

    Suppose I have a table with the fields "location", daily_sales", and "date". There are 3 different locations and I want the Top 3 "daily_sales" for each location. I know this can easily be done using separate queries for each location (i.e., Select Top 3 Daily_Sales from Sales where location =...

Part and Inventory Search

Back
Top