Combine select statements

Gurjeet Singh

13y1.8k

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

3 Replies

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

Mayur Dighe13y ago
Accepted answer
Hey....Michale

You can do it..............Just use OR keyword into your SELECT Statement.

e.g.
select item,balance 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.............
0
Gurjeet Singh13y ago
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
0
Jignesh Trivedi13y ago
hi,

you may also use Union / Union ALL in this case.

Select item,balance from ACTesting where id =(select max(id) from ACTesting where item='1/2')
union all
Select item,balance from ACTesting where id =(select max(id) from ACTesting where item='2/2')
union all
Select item,balance 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 item,balance 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.
0