I have a query that find all requests that take a certain amount of time. The message have a field, correlation_id, which is shared by all messages belonging to that request. Now what I want in the output are all the messages with that correlation_id. In SQL it would look something like this: SELECT * FROM tbl WHERE correlation_id in (SELECT correlation_id FROM tbl WHERE elapsed_time > 4000) Or something to that effect.
Please sign in to leave a comment.