如果sql语句查询出来的数据重复出现,让它只显示一条,如何写?
谢谢!!!
SELECT a.* , b.*,CASE a.State WHEN 1 THEN '启用' WHEN 0 THEN '停用' END AS sstatus FROM CS_CustomerCo a,CS_OperationInfo b WHERE a.id=b.CCID and a.id>0 AND a.State=1 AND b.OPID=190 ORDER BY a.id DESC
谢谢!!!
SELECT a.* , b.*,CASE a.State WHEN 1 THEN '启用' WHEN 0 THEN '停用' END AS sstatus FROM CS_CustomerCo a,CS_OperationInfo b WHERE a.id=b.CCID and a.id>0 AND a.State=1 AND b.OPID=190 ORDER BY a.id DESC
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货