Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file.
In TransactSQL I would do something like this:
select top 3 CustID, TransDate, Amount
where CustID= '12345'
order by TransDate desc.
I believe there must be a more effcient way of getting the latest 3 transactions.
Any help would be greatly appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!