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 gkittelson 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: jacy
  • Order by date
  1. jacy

    Help with SQL (return 2nd/3rd top answers using SUM??)

    of course! thanks a lot
  2. jacy

    Help with SQL (return 2nd/3rd top answers using SUM??)

    thanks... so that would return say S1 10 S2 9 S3 8 If i wanted to get straight to S3 as the third top supplier, could i use the above query and inverse it somehow, and do top 1, just to get one value returned of the 3rd top supplier? thanks a lot for answering
  3. jacy

    Help with SQL (return 2nd/3rd top answers using SUM??)

    Hi, I need to find out the supplier name of the suppliers who supply the second and third largest total quantity of parts (using 2 different SQL statements). If possible I need the SQL to just return a single supplier name (not a list of suppliers in order of Qty - I need to avoid using...

Part and Inventory Search

Back
Top