Need Query help

[anonymous]

I have a table as follows:

Col1 Col2
A 1
AB 2
AC 1
AB 1
C 1
D 1
A 2
E 2
I want the values of Col1 having values both 1 and 2 in Col2 i.e., i want the query to return the values A and AB whic is having values 1 as well as 2 in Col2. Please help me to write a query for this..

[azimmer]

I have a table as follows:

Col1 Col2
A 1
AB 2
AC 1
AB 1
C 1
D 1
A 2
E 2
I want the values of Col1 having values both 1 and 2 in Col2 i.e., i want the query to return the values A and AB whic is having values 1 as well as 2 in Col2. Please help me to write a query for this..

Option #1 (if you only have 1 and 2 in Col2 -- only two entries; i.e. you do not have like Col1=A, Col2=1; Col1=A, Col2=100 -- still to be shown):

select col1
from myTable
group by col1
having count(col1)=2
 

Option #2 (if you need to have exactly 1 and 2 in Col2 for an entry to be shown):

select t1.col1
from myTable t1, myTable t2
where t1.col1=t2.col1
and (t1.col2='1' and t2.col2='2')
 

[anonymous]

Thank you so much, the second option worked...