Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.
SELECT DISTINCT A.CARRIER_ID, MAX (A.EFFECTIVE), A.TRLR_TYPE_ID, A.CURRENT_NUM_VEHICLES, L.NAME FROM TL_RESOURCE_TRLR A, CARRIER_EQUIP B,LANE L WHERE A.CARRIER_ID = B.CARRIER_ID(+) AND A.TRLR_TYPE_ID = B.TRLR_TYPE_ID(+) AND A.LANE_ID = L.ID AND B.CARRIER_ID IS NULL -- EXCLUDE ROWS ADDED BECAUSE OF THE OUTER JOIN GROUP BY a.carrier_id, a.trlr_type_id, current_num_vehicles, L.NAME ORDER BY A.CARRIER_ID ASC;
|SQL query of Oracle 10g database.||8||57|
|SQL Query Syntax Error||9||33|
|Query criteria to get previous month's data not working||3||27|
|Unable to insert second line output line in ODBC connection||4||32|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!