Which join i have to use?

Question

How can comibne below all select statement into one select statement.
Actaully i want max(id ) of each item into one select statement

Select item,balance from ACTesting where id =(select max(id) from ACTesting where item='1/2')

Select item,balance from ACTesting where id =(select max(id) from ACTesting where item='2/2')

Select item,balance from ACTesting where id =(select max(id) from ACTesting where item='2/3')

Gaurav Malviya · Answer

this the solutions of your problem. select distinct itembalance from ACTesting as a where a.id =(select max(id) from ACTesting where item=a.item)