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 derfloh 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: *

  1. foxy69

    Using LAST in PSQL

    This would work but not in every case, the top 4 may only need to be the top 2 depending on th enumber of changes. select top 4 part,component,effectivedate,qty from productstructure where Where Parent = 'MyPart' Order by Component, EffectiveDate desc I think (if I understand correctly what...

Part and Inventory Search

Back
Top