아래처럼 검색을 하면
에러가 뜨는데 왜 그런가요?
1. 검색
SELECT b.sign_action
FROM compli_answer_doc a, hsign_sign b
WHERE a.doc_yearmon = b.doc_yearmon AND a.doc_number = b.doc_number
Group by b.sign_type
Having max(b.sign_seqno)
2. 에러
Incorrect syntax near ')'.
having절에는 min .max를 사용할수 없습니다
create table #temp ( c char(1), d char(1) )
insert #temp values ('c', '1') insert #temp values ('c', '2') insert #temp values ('d', '1') select c, d from #temp group by c, d having max(d) > '1'