如:
存在重复记录的数据结果集:
select BankCode,BankName from dbo.Banks where Userid=1
剔除重复记录后的数据结果集:
select distinct BankCode,BankName from dbo.Banks where Userid=1
望对初学者有用!!!
如:
存在重复记录的数据结果集:
select BankCode,BankName from dbo.Banks where Userid=1
剔除重复记录后的数据结果集:
select distinct BankCode,BankName from dbo.Banks where Userid=1
望对初学者有用!!!