Re: SELECT syntax

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 12:32:24 -0000

SELECT empid, job_date, ...
 FROM Job_History
 WHERE empid = 3130426
  AND job_date >=
   (SELECT MAX(job_date)
    FROM Job_History
    WHERE empid = 3130426
    AND job_date <= '20010101')
 OR NOT EXISTS
  (SELECT *
   FROM Job_History
   WHERE empid = 3130426
    AND job_date <= '20010101') 

-- 
David Portas
SQL Server MVP
--