请问一个关于php+mysql的有关问题

select id,count(uid) from user group by uid having uid=1 or uid=2 or uid =3;

select * from user where uid=1 limit 1;

select * from tbl_name a 
 where (select count(*) from tbl_name where uid=a.uid and id
------解决方案--------------------
每个条件只取一条：
 select * from tt where uid in(1,2,3) group by uid ;
------解决方案--------------------
select  a.*  from  table a where  1> (select count(1) from table b where a.id = b.id and a.id > b.id ) and a.uid in (1,2,3)
------解决方案--------------------
select top 1 * from table group by  id 
------解决方案--------------------
group by 可以实现
声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn核实处理。
专题推荐：nbsp uid select from where

			   上一篇：自动实时更新的页面怎么抓取数据呢求路过的大神指点
			   下一篇：CI框架请问-公司内部CI写的框架，怎么接到美工的HTML做成网站