﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>博客园-宋辉的博客-最新评论</title><link>http://www.cnblogs.com/dfsxh/CommentsRSS.aspx</link><description /><language>zh-cn</language><pubDate>Tue, 10 Apr 2012 10:21:54 GMT</pubDate><lastBuildDate>Tue, 10 Apr 2012 10:21:54 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:w3wp.exe占内存CPU问题 WIN2003 IIS6.0假死现象的分析</title><link>http://www.cnblogs.com/dfsxh/archive/2011/07/28/1598862.html#2162779</link><dc:creator>问题很严重，加班吧。</dc:creator><author>问题很严重，加班吧。</author><pubDate>Thu, 28 Jul 2011 01:34:48 GMT</pubDate><guid>http://www.cnblogs.com/dfsxh/archive/2011/07/28/1598862.html#2162779</guid><description><![CDATA[不错，看看能解决问题不能。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/dfsxh/" target="_blank">问题很严重，加班吧。</a> 2011-07-28 09:34 <a href="http://www.cnblogs.com/dfsxh/archive/2011/07/28/1598862.html#2162779#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:windows API函数说明</title><link>http://www.cnblogs.com/dfsxh/archive/2011/01/10/1890984.html#2007524</link><dc:creator>无邪兮</dc:creator><author>无邪兮</author><pubDate>Mon, 10 Jan 2011 07:43:39 GMT</pubDate><guid>http://www.cnblogs.com/dfsxh/archive/2011/01/10/1890984.html#2007524</guid><description><![CDATA[函数收集好全啊!<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/dfsxh/" target="_blank">无邪兮</a> 2011-01-10 15:43 <a href="http://www.cnblogs.com/dfsxh/archive/2011/01/10/1890984.html#2007524#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:sql存储过程教程 </title><link>http://www.cnblogs.com/dfsxh/archive/2010/07/30/1287228.html#1883904</link><dc:creator>zhao896</dc:creator><author>zhao896</author><pubDate>Fri, 30 Jul 2010 08:42:31 GMT</pubDate><guid>http://www.cnblogs.com/dfsxh/archive/2010/07/30/1287228.html#1883904</guid><description><![CDATA[mark<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/dfsxh/" target="_blank">zhao896</a> 2010-07-30 16:42 <a href="http://www.cnblogs.com/dfsxh/archive/2010/07/30/1287228.html#1883904#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:金蝶的一道SQL笔试题</title><link>http://www.cnblogs.com/dfsxh/archive/2010/07/07/1287241.html#1866114</link><dc:creator>崩溃</dc:creator><author>崩溃</author><pubDate>Wed, 07 Jul 2010 08:45:47 GMT</pubDate><guid>http://www.cnblogs.com/dfsxh/archive/2010/07/07/1287241.html#1866114</guid><description><![CDATA[我去其他公司面试也出过个类似的题目
我记得当时是这样写的：
select 购物人,count(产品) from 表
group by 购物人 
having count(产品) &gt; 2

==================================
看错了，嘿嘿！ 和你是一个道理！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/dfsxh/" target="_blank">崩溃</a> 2010-07-07 16:45 <a href="http://www.cnblogs.com/dfsxh/archive/2010/07/07/1287241.html#1866114#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:金蝶的一道SQL笔试题</title><link>http://www.cnblogs.com/dfsxh/archive/2010/04/19/1287241.html#1804748</link><dc:creator>天涯觅箫声</dc:creator><author>天涯觅箫声</author><pubDate>Mon, 19 Apr 2010 02:50:46 GMT</pubDate><guid>http://www.cnblogs.com/dfsxh/archive/2010/04/19/1287241.html#1804748</guid><description><![CDATA[加入 distinct 关键字便可以解决，如下：

select name as 购物人, count(distinct type) as 种类数
from table
group by name having count(distinct type) &gt;= 2;<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/dfsxh/" target="_blank">天涯觅箫声</a> 2010-04-19 10:50 <a href="http://www.cnblogs.com/dfsxh/archive/2010/04/19/1287241.html#1804748#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
