Thread: by occurence
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 10:29 AM
upx.brussels@gmail.com
 
Posts: n/a
Default by occurence

Hello all

if i have a table containing the follwing

Id --Value
0 -- 15
1 -- 5
2 -- 15
3 -- 4
4 -- 9
5 -- 1
6 -- 4

how can i obtains easily only values repeated more than only one
(where occurence >1)
result:

Id --Value
0 -- 15
2 -- 15
3 -- 4
6 -- 4

thanks in advance

Reply With Quote