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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- foxy69
- Post #4
- Forum: Pervasive: Pervasive.SQL
