Combine select statements

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

Mayur Dighe · Answer

Hey....Michale You can do it..............Just use OR keyword into your SELECT Statement. e.g. select itembalance from ACTesting where id =( select max(id) from ACTesting where item='1/2' OR item='2/2' OR item='2/3' ) Try.... it... it will Work.... Happy Programming.............

Gurjeet Singh · Answer

Dear Mayur Thanx It's working fine. Suppose i have thousands of items then i have to type OR thousand times. Is there any alternative to get Max(id) of Distinct items

Jignesh Trivedi · Answer

hi you may also use Union / Union ALL in this case. Select itembalance from ACTesting where id =(select max(id) from ACTesting where item='1/2') union all Select itembalance from ACTesting where id =(select max(id) from ACTesting where item='2/2') union all Select itembalance from ACTesting where id =(select max(id) from ACTesting where item='2/3') also you may got same out put using mayur suggesion by just replacing = with in select itembalance from ACTesting where id in (select max(id) from ACTesting where item='1/2' OR item='2/2' OR item='2/3' ) hope this will help you.