뭐 간단하게 셀프조인으로 해봤습니다.

create table tblx (
msno int identity
,msname char(10)
,msaddress char (50)
,msdate datetime
,msphone char(13)
)

-- drop table tblx
go

insert into tblx (msname,msaddress,msdate,msphone)
values('쓰레빠','서울 영등포동5가 제일빌딩1층',getdate(),'02667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('김민석','서울 영등포동7가 제일빌딩9층',getdate(),'02667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('김민자','서울 영등포동7가 제일빌딩1층',getdate(),'02667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('써니','서울 영등포동7가 제일빌딩1층',getdate(),'02432667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('쓰레빠','서울 영등포동5가 제일빌딩1층',getdate(),'04322667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('박종열','서울 영등포동5가 제일빌딩1층',getdate(),'43202667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('김민석','서울 영등포동7가 제일빌딩1층',getdate(),'02667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('박종열','서울 영등포동7가 제일빌딩1층',getdate(),'02667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('써니','서울 영등포동7가 제일빌딩1층',getdate(),'02667601')

insert into tblx (msname,msaddress,msdate,msphone)
values('김민석','서울 영등포동7가 제일빌딩1층',getdate(),'02667601')

select * from tblx order by msname

================================

select b.msno,b.msname,b.msaddress,b.msdate,b.msphone from
(select max(msno) as msTopNo ,msname from tblx group by msname) as a inner join
tblx as b on a.msTopNo = b.msno

================================

msno        msname     msaddress                                          msdate                                                 msphone      
----------- ---------- -------------------------------------------------- ------------------------------------------------------ -------------
2           김민석        서울 영등포동7가 제일빌딩9층                                   2005-06-08 02:59:29.643                                02667601    
7           김민석        서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    
10          김민석        서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    
3           김민자        서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    
8           박종열        서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    
6           박종열        서울 영등포동5가 제일빌딩1층                                   2005-06-08 02:59:29.643                                43202667601 
9           써니         서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    
4           써니         서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02432667601 
5           쓰레빠        서울 영등포동5가 제일빌딩1층                                   2005-06-08 02:59:29.643                                04322667601 
1           쓰레빠        서울 영등포동5가 제일빌딩1층                                   2005-06-08 02:59:29.633                                02667601    

(10개 행 적용됨)

msno        msname     msaddress                                          msdate                                                 msphone      
----------- ---------- -------------------------------------------------- ------------------------------------------------------ -------------
3           김민자        서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    
5           쓰레빠        서울 영등포동5가 제일빌딩1층                                   2005-06-08 02:59:29.643                                04322667601 
8           박종열        서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    
9           써니         서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    
10          김민석        서울 영등포동7가 제일빌딩1층                                   2005-06-08 02:59:29.643                                02667601    

아~ 많이 심심하네 -_- 잠도 안오고 ^-^ 열심히 하세요 맥주 한잔 하니 기분 좋습니다. 500반잔 마시고 석이가...

create table temp_table
(이름 varchar(10),
갱신일 varchar(10),
주소 varchar(50),
전화번호 varchar(20)
)

insert into temp_table values  ('홍길동', '2005/02/04', '경기도*********', '3333-4444')
insert into temp_table values  ('홍길동', '2004/03/24', '서울*********', '3333-4444')
insert into temp_table values  ('홍길동', '2002/12/04', '충청도*********', '3333-4444')
insert into temp_table values  ('강남길', '2005/03/13', '서울*********', '3333-4444')
insert into temp_table values  ('강남길', '2002/12/04', '강원도*********', '3333-4444')

select * from temp_table

select a.이름, a.갱신일, a.주소, a.전화번호 from temp_table a
 where a.갱신일 = (select max(갱신일) from temp_table where 이름 = a.이름)

drop table temp_table

역시 여리 선배님이 짠게 빠릅니다.

ㅠ.ㅠ

윈 ~

역시 경력은 못따라 가나봐요 ~

열심히 해야쥐 으싸 으싸~

* 나머지 갱신일을 제외한 데이터는 같거나 출력할 필요가 없으면 이방법이 어떨런지요

select 이름,max(갱신일),전화번호,주소 from temp_table group by 이름,전화번호,주소