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
Example-
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


Subject
Written By
Posted
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, only registered users may post in this forum.

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.