search

Home >Database >Mysql Tutorial > sql之表的表达式

sql之表的表达式

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 17:37:171177browse

1、派生表 实质：就是特殊的子查询（将查询结果放在from后面） 含有一张Order表： 看下面的sql语句： orderid,orderdate,custid ( orderid,orderdate,custid,ROW_NUMBER() ) as t -- 表名必须起别名

1、派生表

实质：就是特殊的子查询（将查询结果放在from后面）

含有一张Order表：

看下面的sql语句：

orderid,orderdate,custid ( orderid,orderdate,custid,ROW_NUMBER() ) as t--表名必须起别名 ，

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： 配置高级复制报ORA-23375解决办法Next article： REDGATE又一好用的脚本工具ScriptsManager1.3

Related articles

See more