I am writing a query in Mysql. I need top 50 transaction for each customer done by customer (ORDER BY TRANSACTION.TRANSACTIONDAT
Also, can I get the transaction count no for each transaction. I mean first transaction placed should have count 1, next one should have count 2 etc
I need to bring this information in my select query.
I am getting all of these transaction details in bulk by excel file and admin can upload excel file as many times as they wanted,
so Its hard to take column 'count' in transaction table.
Please suggest me to bring this information in select query by using function or anything else
Thanks & Regards
TRANSATION.CLIENTID, TRANSACTION.PRODUCTISINCODE, TRANSACTION.TRANSACTIONDATE,TRANSATION.ISAPPROVED