Posted By

sekihin on 08/04/10


Tagged

mssql


Versions (?)

GET MIN CD


 / Published in: SQL
 

  1. SELECT TEMPCD FROM (SELECT (CD+1) AS CD FROM MASTERTABLE) WHERE TEMPCD NOT IN (SELECT CD FROM MASTERTABLE) ORDER BY TEMPCD

Report this snippet  

You need to login to post a comment.