MySQL Forums
Forum List  »  Newbie

SQL query
Posted by: harshith vemula
Date: June 16, 2018 05:46AM

Table name - wallet.
Row names - Balance,user id, transaction id.
I need balance of the userid with highest or maximum Transaction id
Bal. Transaction. User.
100. 5. 1
200. 7. 1
300. 6. 3
If user id=1 Then search for highest transaction I'd in user id=1 it's 7 (from above table) then I need the balance of that transaction id

Options: ReplyQuote

Written By
SQL query
June 16, 2018 05:46AM
June 16, 2018 10:02AM
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.