Re: SQL query
"SELECT balance FROM `wpwoo_wallet_transactions` WHERE `transaction_id`=(SELECT MAX(`transaction_id`) FROM wpwoo_wallet_transactions) AND user_id =1
This is the query i have used.i am getting the balance of maximum transaction id in the whole table but i need the balance of maximum transaction id of the user_id=1
Subject
Written By
Posted
Re: SQL query
June 16, 2018 10:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.