Start with...Connect By子句的应用
摘要：/*Start with...Connect By子句的应用*//* 从树根往叶子递归 */select *from ( select '1' as id, '10' as name,'0' as pid from dual union all select '2','11','1' from dual union all select '3','20','0' from dual union...
阅读全文
posted @
2009-03-10 11:56
Good life
阅读(176)
推荐(0) 编辑
自动滚屏
摘要：<!--<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">--><html xmlns="http://www.w3.org/1999/xhtml"><head>...
阅读全文
posted @
2009-03-10 10:42
Good life
阅读(174)
推荐(0) 编辑
select...count()
摘要：declare @t table( c varchar(10));insert @tselect *from (select 'A' as c union allselect 'B' union allselect 'B' union allselect null union allselect null) t;select count(*) from @t;select count(c) fro...
阅读全文
posted @
2009-03-04 11:23
Good life
阅读(218)
推荐(0) 编辑
