$tblname = "(select c.contractorid,c.contractorname_eng from tb_po2 po, tb_contractor2 c where po.status <> 'X' AND c.contractorid = po.contractorid order by po.last_updated_time desc) as temp limit 5";
$data_array = getallrecord($tblname, "distinct temp.contractorid,temp.contractorname_eng", "", "");
select top 5 c.contractorid,c.contractorname_eng from tb_po2 po, tb_contractor2 c
where po.status <> 'X' AND c.contractorid = po.contractorid
order by po.last_updated_time desc
--去重?select top 5 DISTINCT c.contractorid,c.contractorname_eng from tb_po2 po, tb_contractor2 c
where po.status <> 'X' AND c.contractorid = po.contractorid
order by po.last_updated_time desc
排序,然后能distinct不重复的5条数据
select top 5 DISTINCT c.contractorid,c.contractorname_eng from tb_po2 po, tb_contractor2 c
where po.status <> 'X' AND c.contractorid = po.contractorid
order by po.last_updated_time desc
where po.status <> 'X' AND c.contractorid = po.contractorid
order by po.last_updated_time desc
谁告诉我怎么查出这个查询中c.contractorname_eng不重复的方法
where po.status <> 'X' AND c.contractorid = po.contractorid
order by po.last_updated_time descselect distinct c.contractorid,c.contractorname_eng from tb_po2 po,po.last_updated_time tb_contractor2 c
where po.status <> 'X' AND c.contractorid = po.contractorid
order by po.last_updated_time desc这2句都报错,谁给个类似的查询代码啊
top 5 distinct(temp.contractorid),
temp.contractorname_eng
from
(select
c.contractorid,
c.contractorname_eng
from tb_po2 po,
tb_contractor2 c
where po.status <> 'X' AND c.contractorid = po.contractorid
order by po.last_updated_time desc
) as temp
select
top 5 distinct(temp.contractorid),
temp.contractorname_eng
from
(select
c.contractorid,
c.contractorname_eng
from tb_po2 po,
tb_contractor2 c
where po.status <> 'X ' AND c.contractorid = po.contractorid
order by po.last_updated_time desc
) as temp忘加高亮了