newrelicnrql

How can I compare one field with another in NRQL?

How can I make this kind of query in NRQL?

SELECT origin, destination FROM locations WHERE origin = destination
Solution

  • An option for this to use a subquery like this

    SELECT origin, destination FROM locations WHERE origin IN (SELECT destination FROM locations)