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