Select last 3 transactions
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
from Trans
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.
Suhel.



