at least 100000.

I have to solve the problem by using group by to solve this problem (i have just post the question in this forum titled

Calculation with group...

Thanks for your help. 🙂

As my data is large, from your experiences, is there any alternative that helps me to find the highest distinct records with out having the problem...

Thank you very much for your reply and your solution.

I am not quite sure because it seems that your solution compares the row to the next one which might...

Thanks for replying to my question.

the out come should be something like this because you need to compare each record three times and sum the distinct values and reorder the...

Hi Dave Ballantyne

Thank you for your answer but i would like know that CTE can be used to update random columns. because when i execute the following statement,...