Search results

Hi, I need to compare records in the same table. I know that this is typically accomplished by joining the table with itself. However, this is not entirely suitable for my needs. I need to compare the first record to every other record - excluding itself - and then compare the second record to...

Hello, I'm trying to write a relatively simple function. What I want it to do is count pairs of records within "range" of one another - to determine whether a record is in range or not is trivial. So I want to compare the first record to every other record in the table, second record to every...

Hello, I've been wrestling with this problem for a while now and any assistance would be greatly appreciated. I have a single table containing flight data. Each record represents a single flight. What I'm attempting to do is count of pairs of flights that come within a certain range of each...