摘要：declare @tbl table(name varchar(20),age datetime)insert into @tbl select 'jacky','1985-12-23' union select 'myjacky','1986-12-10' unionselect 'myjacky','1986-12-12' unionselect 'jacky','1988-09-23'--方法一select a.* from @tbl a inner join 阅读全文