MySQL Forums
Forum List  »  Newbie

Re: SQL query
Posted by: harshith vemula
Date: June 16, 2018 10:38AM

"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

Options: ReplyQuote


Subject
Written By
Posted
June 16, 2018 05:46AM
June 16, 2018 10:02AM
Re: SQL query
June 16, 2018 10:38AM
June 16, 2018 11:20AM
June 16, 2018 10:03PM
June 16, 2018 11:06PM


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.