Unanswered: Comparing rows in table against themselves ??
i have a problem in that i dont know how to Comparing rows in table against themselves. at the moments my code looks like :
FETCH Topic_Result_ID Then Insert INTO Sel_Top(Topic_Result_ID = Topic_Result_ID);
IF Topic_Result_ID =
Topic_Result_ID%FOUND > Topic_Result_ID
Where Topic_Result_ID = Selected_Topic_ID
Then Topic_Keyword_Counter ++;
i am trying to find the Topic_Result_ID with the largest number of same values in the table but this is not working