single command

[timmyni]

I have a table users( ...... age int .........)

I want to pick out the users have same age as anyother users. with one SQL statement. How can I do it?

 

[r937]

select foo, bar, age
  from users
 where age in
   ( select age
       from users
     group by age
     having count(*) > 1 )

rudy

http://r937.com/

SQL Consulting

 

[timmyni]

how about this one

select id, age
from users
where age in
( select age
from users
group by age
having count(*) > 1 )

 

[timmyni]

sorry, pasted the wrong one,


SELECT DISTINCT t1.*
FROM try1 AS t1
INNER JOIN try1 AS t2
ON t1.age = t2.age
AND t1.id <> t2.id