Compare between rows in a database

Hi All

I am trying to implement program that enable me to compare between rows in a database. The most major step is how to conduct the comparison between rows.

The normal solution is based on pairwise comparison where you need to compare records against each other. This solution is not the one i look forward as it has very time complexity. Therefore, I am wondering if there is any other algorithm that you suggest to solving this problem in very fast and efficient way.

Thank you very much in advance and I look forward to hearing from you.

You didn't really give enough information to get a reasonable answer. What are you trying to accomplish? Are you trying to find, for example, some certain row with a maximum (or minimum) value in some field? What type of information are you attempting to extract?