Blog

Viewing posts from August, 2008

Excel中删除不重复的行

Posted by: JiaLiang Liao in Windows 15 years, 8 months ago

有客户要求找出Excel文件中的重复行，以避免导入数据是出错。因为文件包含超过10000行，仅标记出重复行也不容易查看，比较好的办法是删除不重复行。

read more / 0 comments

Excel中添加自定义函数和过程

Posted by: JiaLiang Liao in Windows 15 years, 8 months ago

因为自定义的函数并未签署可靠来源，默认Execl安全策略禁止运行宏。选择菜单：工具 → 选项 → 安全性 → 宏安全性 → 安全级，将安全级设置为中，允许运行宏。

read more / 0 comments

MySQL连接查询

Posted by: JiaLiang Liao in Oracle | 数据库 15 years, 9 months ago

左连接（Left Join）查询

read more / 0 comments

Recent Posts

Archive

2019

October (1)
July (2)
June (1)
May (5)
April (1)

2013

May (3)
April (1)
March (1)
February (1)
January (4)

2012

December (2)
November (1)
October (6)
September (6)
August (1)
July (1)
June (1)
May (4)
April (2)
March (6)
February (1)

2011

August (3)
July (2)
June (5)
May (6)
April (3)
March (2)
February (2)
January (4)

2010

December (3)
November (1)
September (2)
August (1)
July (6)
June (4)
May (13)
April (3)
March (1)
January (1)

2009

December (1)
October (2)
September (1)
August (1)
July (2)
June (1)
May (1)
February (2)
January (2)

2008

December (8)
November (5)
October (7)
September (4)
August (3)
July (4)
June (8)
May (7)
April (3)
March (7)
February (5)
January (7)

2007

December (6)
November (7)
October (5)
August (1)
May (1)

Categories

Authors

JiaLiang Liao (214)

Feeds

RSS / Atom