for example. I have one table a (No char(3),Name Varchar(20),Cert_no char(4),Amt Number(16,2))content of table a:
No Name Cert_no Amt
001 joe 0001 10.00
001 joe 0002 20.00
002 joe 0003 30.00
003 mary 0004 40.00I want to select distinct(No,Name) from table a. The result should be :
No Name
001 joe
002 joe
003 maryCan I use one Sql statment to compelete the problem?
No Name Cert_no Amt
001 joe 0001 10.00
001 joe 0002 20.00
002 joe 0003 30.00
003 mary 0004 40.00I want to select distinct(No,Name) from table a. The result should be :
No Name
001 joe
002 joe
003 maryCan I use one Sql statment to compelete the problem?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货