- 博客(14)
- 资源 (2)
- 收藏
- 关注
原创 分析函数 应用
把普通两个表通过函数查询得到收发存报表 CREATE FUNCTION R_I_INOUTSTOR(@FROMDATE DATETIME, @TODATE DATETIME) RETURNS @TempTable TABLE (STORE VARCHAR(80), BD DATETIME, BC VARCHAR(80),GOODS VARCHAR(80) ,
2009-07-23 21:17:00 288
原创 Hierarchical query 应用
SQL> select * 2 from movie 3 ;MOVIENO MOVIENAME-------- --------------------09062501 功夫09062502 如来神掌SQL> select * 2 from sell 3 ;BUYNO BUYTIME------- --------------0906201 06-2月 -070906202
2009-07-22 23:10:00 260
原创 使用 start with ...connect by ...合并一个列中的值
select *from Lift_tabel ;--------------------------------------------------------------------------------------------------------------------- GROUP_NO DEVICE LIFT_NO LIFT_NAME 1 1 1
2009-07-21 22:30:00 347
转载 Pseudocolumns 伪列
A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update, or delete their values. Hierarchical Quer
2009-07-17 15:48:00 360
转载 Hierarchical Queries 分等级的查询
Hierarchical Queries If a table contains hierarchical data, then you can select rows in a hierarchical order using the hierarchical query clause:hierarchical_query_clause::=Description of the il
2009-07-16 01:11:00 385
转载 Multiset Operators 集合运算符
Multiset Operators Multiset operators combine the results of two nested tables into a single nested table.The examples related to multiset operators require that two nested tables be created and
2009-07-16 00:03:00 454
转载 暂存笔记 in_conditions
IN in_conditions::=An in_condition is a membership condition. It tests a value for membership in a list of values or subquery Table 6-11 IN Conditions Type of ConditionOpera
2009-07-15 23:51:00 303
原创 每班总分前3名的记录
SQL> select * from t 2 ;GRADE NO NAME MARK---------- ------ ---------- ----------1 1 a 11 2 b 21
2009-07-13 22:08:00 312
转载 Analytic Functions
Analytic Functions Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of
2009-07-08 01:34:00 381
转载 Function--------LEAD & LAG
LEAD SyntaxLEAD(value_expr [, offset ] [, default ])OVER ([ query_partition_clause ] order_by_clause)See Also:"Analytic Functions " for information on syn
2009-07-07 17:01:00 358
转载 Comparison Conditions
Comparison Conditions Comparison conditions compare one expression with another. The result of such a comparison can be TRUE, FALSE, or NULL.Large objects (LOBs) are not supported in compari
2009-07-06 17:25:00 298
原创 Oracle中的单引号‘’和双引号“”
都是从网络上粘贴过来的,待以后积累得差不多了再总结。 1、在Oracle中:双引号的作用是:如果创建对象的时候,对象名、字段名加双引号,则表示Oracle将严格区分大小写,否则Oracl都默认大写。而单引号则表示:这个加了单引号的字段是一个字类似字符串,并不区分大小写。所在在查询表 select * from "emp";的时候只会查询表名为小写的emp的表,而Oracle中的默认是大
2009-07-04 16:59:00 305
转载 Function-------DECODE & NVL
---------------------DECODE( )Syntax DECODE(expr, search, result [, search, result ]... [, default ] ) PurposeDECODE compares expr to each search value one by
2009-07-04 16:34:00 366
作业成本法的研究在中国的发展.pdf
2011-02-14
VBA 图表 数据标签 图片或纹理填充 插入自 剪贴板,用VBA怎么写?
2022-10-15
TA创建的收藏夹 TA关注的收藏夹
TA关注的人