작성일 : 12-07-27 15:17
|
[MsSQL] EXISTS 하위쿼리에 조건을 걸때 사용 가능함
|
 |
|
글쓴이 :
조형래
 조회 : 5,430
|
SAMPLE
FROM USER AS US WHERE EXISTS(SELECT LRN_SEQ FROM S_TB_LRNINFO WHERE USER_ID = US.USER_ID AND LRNINFO_FEDATE >= '2012-07-27' AND LRNINFO_FEDATE <= '2012-07-31' AND LRN_SEQ IN (SELECT TOP 1 LRN_SEQ FROM S_TB_LRNINFO WHERE USER_ID = US.USER_ID ORDER BY 1 DESC))
|
|
1027
