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 |