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.