Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Search results for query: *

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

    Select but not quite distinct =)

    Hi! I have a problem figuring out how to formulate my select-query. I will try to illustrate my problem :) Table: col1 | col2 ----------- A | 10 B | 13 B | 14 C | 11 I want to select every distinct occurence in col1 choosing the record with the highest value in col2, ie. i...

Part and Inventory Search

Back
Top Bottom