Hicreate table #tmp(ID1 int, id2 int)Insert into #tmpSELECT 1 , 98 UNION ALLSELECT 1 , 97 UNION ALLSELECT 1 , 97 UNION ALLSELECT 1 , 97 UNION ALLSELECT 1 , 97 UNION ALLSELECT 1 , 96 UNION ALLSELECT 1 , 96 UNION ALLSELECT 1 , 96 UNION ALLSELECT 1 , 95 UNION ALLSELECT 1 , 94 UNION ALLSELECT 2 , 98 UNION ALLSELECT 2 , 98 UNION ALLSELECT 2 , 98 UNION ALLSELECT 2 , 97 UNION ALLSELECT 2 , 97 UNION ALLSELECT 2 , 97 UNION ALLSELECT 2 , 97 UNION ALLSELECT 2 , 96 UNION ALLSELECT 2 , 96 UNION ALLSELECT 2 , 95 UNION ALLSELECT 3 , 98 UNION ALLSELECT 3 , 98 UNION ALLSELECT 3 , 98 UNION ALLSELECT 3 , 97 UNION ALLSELECT 3 , 96 UNION ALLSELECT 3 , 96 UNION ALLSELECT 3 , 96 UNION ALLSELECT 3 , 95 UNION ALLSELECT 3 , 95 UNION ALLSELECT 3 , 94 UNION ALLSELECT 4 , 98 UNION ALLSELECT 4 , 97 UNION ALLSELECT 4 , 97 UNION ALLSELECT 4 , 97 UNION ALLSELECT 4 , 96 UNION ALLSELECT 4 , 96 UNION ALLSELECT 4 , 96 UNION ALLSELECT 4 , 95 UNION ALLSELECT 4 , 95 UNION ALLSELECT 4 , 94 UNION ALLSELECT 5 , 98 UNION ALLSELECT 5 , 97 UNION ALLSELECT 5 , 97 UNION ALLSELECT 5 , 97 UNION ALLSELECT 5 , 97 UNION ALLSELECT 5 , 97 UNION ALLSELECT 5 , 96 UNION ALLSELECT 5 , 96 UNION ALLSELECT 5 , 95 UNION ALLSELECT 5 , 94
I have table data like this...so i need to find out the id2 columns the combination of same order data with each id1 value(group by id1)which means1 , 981 , 971 , 971 , 971 , 971 , 961 , 961 , 961 , 951 , 94
I need to find out the entire table is there any same order of data repeated in table...so i need to each combination..only for id2 values with same order..please help outsorry about my english...
QUERY FOR COMBINATION
Posted - 2009-10-20 : 08:27:19
