Loading

Which join i have to use?

Gurjeet Singh

13y1.5k

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')

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Gaurav Malviya13y ago
this the solutions of your problem.

select distinct item,balance from ACTesting as a where a.id =(select max(id) from ACTesting where item=a.item)
0