I need a SELECT statement that will return the latest transaction row per Customer.
Below is a test database, with test data, followed by 3 select statements. None of the SELECT statements are quite what I need.
Any help would be much appreciated.
CREATE TABLE CUST
...
2 results in 0.0020 seconds.
-
SQL SELECT to retrieve last transaction Row per Customer
-
How do I duplicate Query/400 join type 3 with a join logical?
I have a query that gives me the results I want using a join type 3 (unmatched records with primary file), and I want to create a join logical file that will give the same results.
Basically, both files contain order data. I want to join on order number and only include the records from...