select * from table where id in (select min(id) from table group by name)
select * from tab union all (select * from tab_1 union all select * from tab_2) order by id desc
select count(id) from table group by 要统计的字段 (id是什么都可以,只要不是聚合本身就可以)
min max count sum都是聚合才能使用的函数( count(*)除外 )
<LINK href="body.css" type=text/css rel=stylesheet>
body.css
td {
font-family:"lucida grande", Verdana, lucida, Arial, Helvetica, 宋体, sans-serif;
font-size:12px;
font-color:white
}
a.tt:link{text-decoration:none;color:#CC0000;}
a.tt:visited {font-size: 9pt;color: #CC0000;}
a.tt:hover {font-size: 9pt;color: #FF3366;background-color:#CCCCCC}
a:link{ text-decoration:none; color:#blue; }
a:visited{ text-decoration:none; color:#blue; }
a:hover{ text-decoration:none; color:#blue; }
a:active{ text-decoration:none; color:#blue; }
.12px{
font-size:12px; color:#000000;
}
p{
line-height:24px; font-size:14px;
}
form {
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
}
input { font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;}
.style1 { border: 1px; border-style:solid; border-width: 0px 1px 1px 1px; border-color:#FFCC00 #FFCC00 #FFCC00 #FFCC00 }
<div id="member"></div>
样式表:#member{margin:0px;color:#66;}

2479

被折叠的 条评论
为什么被折叠?



