Wednesday, 11 September 2013

sql different name but same value

sql different name but same value

I am having value like this
ID | Value
—- ——–
1000 1
1000 2
1000 3
1001 2
1001 3
1001 4
1001 5
I want the output like this
1000 | 1
1000 | 1
1000 | 1
1001 | 2
1001 | 2
1001 | 2
1001 | 2
Please Help..

No comments:

Post a Comment