How to get the nth similar nodes in node similarity algorithm

Neo4j Graph Platform
1

I ran similarity algo (GDS) on a memory graph, this gives me this result (showing the result in the table format):

1
11194×414 41.9 KB

If I want to return the top similarity pair, I can use limit 1 instead of 3 to get the top result. (Result with the maximum similarity).

But I want to only return the third most similar similarity pair, how can I do that?
Basically, my result should be something like this:

2
21134×224 5.79 KB

2

Hello @abhishekjayant1 :slight_smile:

You should have a look at SKIP, in your case:

ORDER BY similarity DESC SKIP 2 LIMIT 1

Regards,
Cobra

3

Hi @Cobra , thanks for helping out again :slight_smile: . This is exactly what I wanted.
However, can you also tell me how to exclude the duplicate similarity pair when I run the node similarity algo. I've shown the duplicate pairs below:

1
11232×619 65.6 KB

I get these duplicate pairs, how can I get rid of these?
PS: I do now want to use write mode, only want to use stream.

4

You can modify your WHERE clause like this:

WHERE n1:Adverse_Event
AND n2:Adverse_Event
AND id(n1) > id(n2)
5

Solved the problem. Thank you so much! :grin: