how to filter an id for subcategory in sql
- by Naim Nsco
i have create one table with A is 1,2,3 and B is 3,5,5,9,10,10
For example, i want to change from this table
NP A B C
1 1 3 why not
1 1 5 weigh
1 1 5 hello
1 1 9 no way
1 1 10 now or never
1 1 10 float the boat, capt
ain
1 1 12 no nelp
2 2 4 why
2 2 6 way too much
2 2 11 help
3 3 1 not now
3 3 2 not
3 3 7 milky way
3 3 7 this is stupid
3 3 8 one way
To be like this:-
A B C
---------- -- --------
1 3 why not
5 weigh
5 hello
9 no way
10 now or never
10 float the boat, capt
ain
12 no nelp
2 4 why
6 way too much
11 help
3 1 not now
2 not
7 milky way
7 this is stupid
8 one way
How to do like that?. Anyone know about this?.