대소문자 구분 > db

직접 돌려봐야 무슨말인지 안 다는거~~~ ㅋㅋ

create table seobangnim (
id varchar(5),
name varchar(5) )
go

insert into seobangnim values ('aaa', '에이')
insert into seobangnim values ('bbb', '비')
insert into seobangnim values ('ccc', '시')
insert into seobangnim values ('ddd', '디')
insert into seobangnim values ('eee', '이')
insert into seobangnim values ('AAA', '중복')
insert into seobangnim values ('CCC', '중복')
go

select * from seobangnim

select id ,count(*)
   from seobangnim
 group by id
having count(*) >1

Select A.id, B.id
From
(
 select id
    from seobangnim
  group by id
 having count(*) >1
) As A
Inner Join seobangnim As B On A.id = B.id