随笔分类 - SQL
摘要：Work with recursive CTEs bookmark_border In GoogleSQL for BigQuery, a WITH clause contains one or more common table expressions (CTEs) with temporary
阅读全文
摘要：Formats for quoted literals The following table lists all of the ways you can format a quoted literal. LiteralExamplesDescription Quoted string "abc"
阅读全文
摘要：IF CURSOR_STATUS('global', 'mycursor') >= 0BEGIN PRINT 'Cursor exists and is open';ENDELSEBEGIN PRINT 'Cursor does not exist or is not open';END; REF:
阅读全文
摘要：Creating a temporary table The following example creates a temporary table named Example and inserts values into it. CREATE TEMP TABLE Example( x INT6
阅读全文
摘要：VALUES Statement | 6.3.x | Cloudera Documentation SELECT now() as date_DES UNION ALL SELECT trunc(now(), 'month') union all select date_sub(trunc(now(
阅读全文
摘要：【转载须知】转载请标注本文链接。 Kettle版本：7.1 E:\迅雷下载\Kettle-pdi-ce-7.1.0.0-12\data-integration 运行spoon.bat 新建-数据库 报错内容： org.pentaho.ui.xul.XulException: org.pentaho.
阅读全文
摘要：有表A，结构如下： A: p_ID p_Num s_id 1 10 01 1 12 02 2 8 01 3 11 01 3 8 03 其中：p_ID为产品ID，p_Num为产品库存量，s_id为仓库ID。请用SQL语句实现将上表中的数据合并，合并后的数据为： p_ID s1_id s2_id s3_
阅读全文
摘要：【转载须知】转载请标注本文链接地址。 安装包：mysql-installer-community-8.0.20.0.msi MySQL安装版本：8.0.20 环境：WIN 7 -64位 安装MySQL server时，Creating uer accounts时报错： Attempting to s
阅读全文
摘要：下载： https://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-20.html 手册： https://community.cloudera.com/t5/Community-Articles/Connect-Oracle-SQL-De
阅读全文
摘要：ref： https://blog.csdn.net/xiaolinyouni/article/details/6943337 现在有一个表student 结构如下：id name class blood1 张三 1 A2 李四 2 C3 王五 1 B4 黄六 3 D5 朱八 2 C现在想查询出每个
阅读全文
