SQL - How do I exclude results with the most recent date? : I am very new to SQL and have been learning as I go by just googling and experimenting. I am trying to get all workstation names, jobstream names and valid from dates where there are duplicates in both the workstation and jobstream columns. I currently have the below query:

    SELECT   T2.WORKSTATION_NAME,T2.JOB_STREAM_NAME,T2.JOB_STREAM_VALID_FROM
    FROM     (SELECT  JOB_STREAM_REFS_V.WORKSTATION_NAME,
             JOB_STREAM_REFS_V.JOB_STREAM_NAME
    FROM     MDL.JOB_STREAM_REFS_V AS JOB_STREAM_REFS_V
    GROUP BY WORKSTATION_NAME,JOB_STREAM_NAME
    HAVING   COUNT(JOB_STREAM_NAME) > 1
    ORDER BY WORKSTATION_NAME,JOB_STREAM_NAME) T1
    JOIN MDL.JOB_STREAM_REFS_V T2 ON T1.WORKSTATION_NAME = T2.WORKSTATION_NAME AND T1.JOB_STREAM_NAME = T2.JOB_STREAM_NAME

This gives the below results which is what I'd expect:

    WORKSTATION_NAME	JOB_STREAM_NAME 	JOB_STREAM_VALID_FROM 
    -------------------------------------------------------------
    STATION1 			STREAMA 			2015-04-26 
    STATION1 			STREAMA 			2015-04-27 
    STATION2 			STREAMB 			2016-04-05 
    STATION2 			STREAMB 			2016-07-25 
    STATION2 			STREAMB 			2016-09-05 
    STATION2 			STREAMB 			2017-07-25 
    STATION2 			STREAMC 			2016-09-21 
    STATION2 			STREAMC 			2016-10-21 
    STATION3 			STREAMD 			2016-08-08 
    STATION3 			STREAMD 			  
    STATION3 			STREAME 			2016-09-04 
    STATION3 			STREAME 			 

However I want to exclude the most recent entry for each workstation/jobstream based on the valid from dates and only return results with older valid from dates or with no valid from date, so that I only get the below:

    WORKSTATION_NAME	JOB_STREAM_NAME 	JOB_STREAM_VALID_FROM 
    -------------------------------------------------------------
    STATION1 			STREAMA 			2015-04-26 
    STATION2 			STREAMB 			2016-04-05 
    STATION2 			STREAMB 			2016-07-25 
    STATION2 			STREAMB 			2016-09-05 
    STATION2 			STREAMC 			2016-09-21 
    STATION3 			STREAMD 			  
    STATION3 			STREAME 			 

I'm at a total loss at this point and not sure how to approach this. I've tried using MAX to get the latest dates and show only everything older than that using WHERE but I could not get it to work, I'm not sure where to even place those statements in my query and there is a slight chance I am in over my head.

Thanks in advance