BlogJava-水煮三国-最新评论http://www.blogjava.net/os586/CommentsRSS.aspx孤单是一个人的狂欢，狂欢是一群人的孤单zh-cnSat, 01 Aug 2009 03:09:25 GMTSat, 01 Aug 2009 03:09:25 GMTcnblogsre: document.getElementsByName()的用法http://www.blogjava.net/os586/archive/2009/06/22/41754.html#283624发展发展Mon, 22 Jun 2009 09:51:00 GMThttp://www.blogjava.net/os586/archive/2009/06/22/41754.html#283624

发展 2009-06-22 17:51 发表评论
]]>re: 贴一道SQL面试题,希望大家相互讨论http://www.blogjava.net/os586/archive/2009/05/21/70436.html#271915luguoluguoThu, 21 May 2009 04:57:00 GMThttp://www.blogjava.net/os586/archive/2009/05/21/70436.html#271915(
select t2.customerName from sales as t2 where t1.customerName = t2.customerName
group by t2.customerName
having (count(t2.customerName) >= 2)
)

luguo 2009-05-21 12:57 发表评论
]]>re: 贴一道SQL面试题,希望大家相互讨论http://www.blogjava.net/os586/archive/2009/03/21/70436.html#261273liweibirdliweibirdSat, 21 Mar 2009 15:53:00 GMThttp://www.blogjava.net/os586/archive/2009/03/21/70436.html#261273select * from T1
where customer_name in
(select customer_name
from T1 as b
group by customer_name
having count(distinct trade_name)>=2)

liweibird 2009-03-21 23:53 发表评论
]]>re: 贴一道SQL面试题,希望大家相互讨论http://www.blogjava.net/os586/archive/2009/02/20/70436.html#255795畅畅畅畅畅畅Fri, 20 Feb 2009 03:58:00 GMThttp://www.blogjava.net/os586/archive/2009/02/20/70436.html#255795| cp_name | cp_kind | cp_count |
+---------+---------+----------+
| A | a | 1 |
| A | c | 2 |
| A | t | 1 |
| B | t | 1 |
| B | a | 2 |
| C | d | 1 |
| D | c | 2 |
| C | d | 3 |
+---------+---------+----------+
上面两道答案明显错误，题目的意思是返回购买“两种或两种商品以上“的客户信息。
正确答案应该是：
select t.cp_name,t.cnt from (select cp_name,count(distinct cp_kind) as cnt from chanpin group by cp_name) t where t.cnt>=2;


畅畅畅 2009-02-20 11:58 发表评论
]]>re: SQL 经典面试题集http://www.blogjava.net/os586/archive/2009/02/17/70461.html#255152畅畅畅畅畅畅Tue, 17 Feb 2009 09:24:00 GMThttp://www.blogjava.net/os586/archive/2009/02/17/70461.html#255152

畅畅畅 2009-02-17 17:24 发表评论
]]>re: SQL 经典面试题集http://www.blogjava.net/os586/archive/2009/02/17/70461.html#255149畅畅畅畅畅畅Tue, 17 Feb 2009 09:19:00 GMThttp://www.blogjava.net/os586/archive/2009/02/17/70461.html#255149select distinct b1.目的地 from B b1,(select 目的地 from B where 起始地='A') as b2 where b1.起始地=b2.目的地 or b1.起始地='A';

畅畅畅 2009-02-17 17:19 发表评论
]]>re: ANT: 一个通用Build.xml模板的建立[转自蚂蚱Blog]http://www.blogjava.net/os586/archive/2009/01/08/75819.html#250544jfkdjfkdThu, 08 Jan 2009 13:53:00 GMThttp://www.blogjava.net/os586/archive/2009/01/08/75819.html#250544

jfkd 2009-01-08 21:53 发表评论
]]>re: document.getElementsByName()的用法http://www.blogjava.net/os586/archive/2008/08/12/41754.html#221435老鼠老鼠Tue, 12 Aug 2008 02:18:00 GMThttp://www.blogjava.net/os586/archive/2008/08/12/41754.html#221435

老鼠 2008-08-12 10:18 发表评论
]]>re: document.getElementsByName()的用法http://www.blogjava.net/os586/archive/2008/06/30/41754.html#211585我爱中国我爱中国Mon, 30 Jun 2008 02:14:00 GMThttp://www.blogjava.net/os586/archive/2008/06/30/41754.html#211585

我爱中国 2008-06-30 10:14 发表评论
]]>re: 贴一道SQL面试题,希望大家相互讨论http://www.blogjava.net/os586/archive/2008/06/05/70436.html#205960beebebeebeWed, 04 Jun 2008 23:00:00 GMThttp://www.blogjava.net/os586/archive/2008/06/05/70436.html#205960 select userName as name,count(userName) as cnt
from exam1
group by userName)t
where t.cnt>=2

beebe 2008-06-05 07:00 发表评论
]]>re: 让dreamweaver 支持Struts标签库[未登录]http://www.blogjava.net/os586/archive/2008/05/28/98722.html#203537useruserWed, 28 May 2008 08:03:00 GMThttp://www.blogjava.net/os586/archive/2008/05/28/98722.html#203537

user 2008-05-28 16:03 发表评论
]]>re: SWT:GridLayout 的使用需要注意的事项[未登录]http://www.blogjava.net/os586/archive/2008/05/26/69111.html#202828javaboyjavaboyMon, 26 May 2008 01:20:00 GMThttp://www.blogjava.net/os586/archive/2008/05/26/69111.html#202828

javaboy 2008-05-26 09:20 发表评论
]]>re: 说说在NEC笔试的感受http://www.blogjava.net/os586/archive/2008/05/25/65955.html#202792流浪人流浪人Sun, 25 May 2008 14:51:00 GMThttp://www.blogjava.net/os586/archive/2008/05/25/65955.html#202792

流浪人 2008-05-25 22:51 发表评论
]]>re: JSP及Servlet当中的重定向技巧http://www.blogjava.net/os586/archive/2008/05/25/38522.html#202726流浪人流浪人Sun, 25 May 2008 07:20:00 GMThttp://www.blogjava.net/os586/archive/2008/05/25/38522.html#202726而在后边你又提到“forward()方法也可以传递查询参数及值。但是<jsp:forward>则不能传递查询参数，如果要实现查询参数则必须嵌套<jsp:param name="name" value="value">来完成”
这2句话不矛盾吗？
与其这样说 是不是 说forward()在某些条件之外都可以传递参数和值更好？？？？




流浪人 2008-05-25 15:20 发表评论
]]>re: 说说在NEC笔试的感受http://www.blogjava.net/os586/archive/2008/05/16/65955.html#200936济南学生济南学生Fri, 16 May 2008 07:43:00 GMThttp://www.blogjava.net/os586/archive/2008/05/16/65955.html#200936您的文章给我启发很大，能不能说几个题目呢，具体点。谢谢咯

济南学生 2008-05-16 15:43 发表评论
]]>re: document.getElementsByName()的用法http://www.blogjava.net/os586/archive/2008/05/11/41754.html#199904三笑三笑Sun, 11 May 2008 15:01:00 GMThttp://www.blogjava.net/os586/archive/2008/05/11/41754.html#199904

三笑 2008-05-11 23:01 发表评论
]]>re: document.getElementsByName()的用法http://www.blogjava.net/os586/archive/2008/04/30/41754.html#197529张群喜张群喜Wed, 30 Apr 2008 07:09:00 GMThttp://www.blogjava.net/os586/archive/2008/04/30/41754.html#197529

张群喜 2008-04-30 15:09 发表评论
]]>re: ForwardAction解决我们的页面转向问题[未登录]http://www.blogjava.net/os586/archive/2008/04/24/97708.html#195586allennyallennyThu, 24 Apr 2008 06:58:00 GMThttp://www.blogjava.net/os586/archive/2008/04/24/97708.html#195586

allenny 2008-04-24 14:58 发表评论
]]>re: 说说在NEC笔试的感受[未登录]http://www.blogjava.net/os586/archive/2008/03/21/65955.html#187766abcabcFri, 21 Mar 2008 10:32:00 GMThttp://www.blogjava.net/os586/archive/2008/03/21/65955.html#187766

abc 2008-03-21 18:32 发表评论
]]>re: Ant:编写build.xml的方法http://www.blogjava.net/os586/archive/2008/03/17/75826.html#186701dwqdwqMon, 17 Mar 2008 02:20:00 GMThttp://www.blogjava.net/os586/archive/2008/03/17/75826.html#186701

dwq 2008-03-17 10:20 发表评论
]]>