How get in SQL pairs of connections in a FW Logs

0 votes

1 answer

54 views

vertica

                          I have a database with orign_ip, destination_ip, and other columns.
I am looking for a way to get in SQL just the connections between two IP's, I need to get just the list.
This is my first step :

    SELECT DISTINCT orig_h , resp_h from gustavo.conn;
     - 15.214.135.70	            15.214.159.100
     - 15.214.136.45	            15.214.137.70

But How I can get from this result the just the rows that match with  

    15.214.135.70	            15.214.159.100

Asked by grojas123 (1 rep)

Aug 20, 2019, 09:34 PM
Last activity: Aug 21, 2019, 06:12 PM

How get in SQL pairs of connections in a FW Logs

Related Questions