我在名为 ads 的表中有这些值:
id sitecatid locationid
1 12 3
2 12 6
3 12 8
4 12 8
5 12 8
6 10 18
7 13 20
8 14 21
我想返回这样的结果:
sitecatid locationid
12 3
10 6
13 8
14 18
20
21
基本上,我只想要具有唯一 sitecatid
和 locationid的任何记录的第一个实例。我试过这个查询但结果不正确:
SELECT DISTINCT sitecatid, locationid
FROM advertisements
WHERE MATCH (sitetitle,sitedescription)
AGAINST ('$q' IN BOOLEAN MODE) AND status='approved'
select b.sitecatid,d.locationid from
(SELECT @rownum := @rownum + 1 AS row_number,
a.sitecatid
FROM (SELECT DISTINCT sitecatid
FROM tbl_test) a
, (SELECT @rownum := 0) r) as b
right join
(SELECT @rownum_2 := @rownum_2 + 1 AS row_number,
c.locationid
FROM (SELECT DISTINCT locationid
FROM tbl_test) c
, (SELECT @rownum_2 := 0) s) as d
on b.row_number = d.row_number
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句