`
文章列表
ram -random access memory rom -read only memory RAM 是随机存取存储器,它的特点是易挥发性,即掉电失忆。 ROM 通常指固化存储器(一次写入,反复读取),它的特点与RAM 相反。ROM又分一次性固化、光擦除和电擦除重写两种类型 操作系统的堆栈和数据机构里的堆栈是有区别的: http://blog.csdn.net/li_007/archive/2007/12/08/1924867.aspx http://www.chinaunix.net/jh/23/477573.html http://hi.baidu.com/xizenyin/blog ...
http://student.csdn.net/space.php?uid=45153&do=thread&id=3274 Linux启动过程的剖析能帮助那些想深入学习Linux用户建立一个相关Linux启动过程的清晰概念,进而可以进一步研究Linux接下来是如何工作的。 Linux启动过程如下:当用户打开PC的电源,BIOS开机自检,按BIOS中设置的启动设备(通常是硬盘)启动,接着启动设备上安装的引导程序lilo或grub开始引导Linux,Linux首先进行内核的引导,接下来执行init程序,init程序调用了rc.sysinit和rc等程序,rc.sysinit和rc当 ...
http://www.cnblogs.com/wennxxin/archive/2008/10/11/1308516.html <FRAME>必须在 <FRAMESET> 范围中使用; <FRAME>不能放在<body>中; <IFRAME>围着的字句只有在浏览器不支持 iframe 标记时才会显示;一定要使用</iframe>关闭,否则后面的内容显示不出来; 嵌套在frameSet中的iframe必需放在body中;不嵌套在frameSet中的iframe可以随意使用; frame的高度只能通过frameSet控制;i ...
使用的是birt2.5;birt designer中预览chart报表没问题;部署到tomcat中访问的时候报NullPointerException: 引用 java.lang.NullPointerException at org.eclipse.birt.chart.reportitem.ChartReportItemImpl.doCompatibility(ChartReportItemImpl.java:302) at org.eclipse.birt.chart.reportitem.ChartReportItemImpl.deserialize(ChartReportItemI ...
在设置webwork的devMode为true后,启动时出现下列异常: 引用com.opensymphony.xwork.interceptor.ParametersInterceptor - Developer Notification (set webwork.devMode to false to disable this message): No object in the CompoundRoot has a publicly accessible property named 'Submit' (no setter could be found) 原因就是devMode下form ...
遇到的问题: 一 用工具建了个表t_aaa(工具生成的create table语句自动为表名加上了引号);然后执行 引用select * from t_aaa 结果提示“表或视图不存在”; 二 有表A,含列id(列id为小写);执行 引用select id from A 提示“ORA-00904:  invalid identifier” 结论: 1 oracle在创建对象时,字符都变为大写,除非他被"引住。 2 查找对象时,对象名前后不带双引号,oracle自动去查找名字全是大写的对象; 3 如果创建对象时对象名是被"引住的,则对象名严格按引号里的大小写来;并且在操作 ...
Finding Duplicates with SQL Here's a handy query for finding duplicates in a table. Suppose you want to find all email addresses in a table that exist more than once: SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 ) You could also use t ...

SQL DISTINCT

SQL 
http://www.sql-tutorial.com/sql-distinct-sql-tutorial/ distinct多列时,返回的是多列 combination 后的 unique 结果。
http://superman-chenzs.itpub.net/post/29327/276049 笛卡尔积: cross join Join Types: 1. Inner Join - Equal-Join - Non-Equal-Join 2. Outer Join - Left-Outer-Join - Right-Outer-Join 3. Self Join - Join a table to itself - Using the table's alias name to complete the self join. - attention the repeat line ...
http://superman-chenzs.itpub.net/post/29327/274808 - figer: function_name [(arg1,arg2,...)] - Manipulate data items - Accept arguments and return one value - Act on each row returned - Return one result per row - May modify the data type - Can be nested - Accept arguments which can be a column or an ...
http://superman-chenzs.itpub.net/post/29327/273849 SELECT *|{[DISTINCT] column|expression [alias],...} FROM table [WHERE condition(s)] [ORDER BY Clause]; Limiting the Rows Selected * Restrict rows returned by using the WHERE clause. --------------------------------------------------------------- ...
http://superman-chenzs.itpub.net/post/29327/276061 GROUP FUNCTIONS operate on sets of rows to give one result per group. Types: - AVG - COUNT - MAX - MIN - STDDEV:标准偏差 - SUM - VARIANCE:方差 Syntax: SELECT [column,] group_function(column),.. FROM table [WHERE condition] [GROUP BY column] [HAVING group ...
http://superman-chenzs.itpub.net/post/29327/272469 truncate的作用是清空一个表格,在删除数据方面,其与delete有一些区别,最近根据在网上和老师的搜集以及培训中的总结,现将其总结如下,以便自己记住: 1、在功能上,truncate是清空一个表的内容,它相当于delete from table_name。 2、delete是dml操作,truncate是ddl操作;因此,用delete删除整个表的数据时,会产生大量的roolback,占用很多的rollback segments, 而truncate不会。 3、在内存中,用delete ...
http://www.techonthenet.com/oracle/functions/to_char.php http://hi.baidu.com/djx_5211314/blog/item/4fec8713905df5826438db47.html In Oracle/PLSQL, the to_char function converts a number or date to a string. The syntax for the to_char function is: to_char( value, [ format_mask ], [ nls_language ] ...
test table: create table test( id number(2) primary key , year number(4), month number(2), income number(8) ) 测试数据: id年月收入1200821002200972003 2009 93004 2009 11400 按年、季收入情况分组的SQL语句: select year,to_char(to_date(concat(year,month),'yyyymm'),'Q') as quater,sum(income) from test group by ...
Global site tag (gtag.js) - Google Analytics