`
收藏列表
标题 标签 来源
多行合并 database(数据库), mysql 
select ROW_ID,group_concat(CODE order by CODE separator ",") as CODE
from MD_MATERIAL_SPECIFIC
group by ROW_ID
ROWNUMBER OVER() database(数据库), sort(排序) http://blog.csdn.net/wangjiang87/article/details/5391600 
--oracle
SELECT ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...) SEQ,T.* FROM ... T;

-- oracle 取前10条数据
SELECT *
  FROM (SELECT ROW_NUMBER() OVER(ORDER BY ...) SEQ, T.*
          FROM ... T) TEMP
 WHERE TEMP.SEQ < 11;

--db2
SELECT ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...) SEQ,T.* FROM ... T;
或
SELECT ROWNUMBER() OVER (PARTITION BY ... ORDER BY ...) SEQ,T.* FROM ... T;

--db2取前10条数据
SELECT *
  FROM (SELECT ROW_NUMBER() OVER(ORDER BY ...) SEQ, T.*
          FROM ... T) TEMP
 WHERE TEMP.SEQ < 11;
或
SELECT *
  FROM (SELECT ROW_NUMBER() OVER(ORDER BY ...) SEQ, T.*
          FROM ... T) AS TEMP
 WHERE TEMP.SEQ < 11;
或 
SELECT *
  FROM (SELECT ROWNUMBER() OVER(ORDER BY ...) SEQ, T.*
          FROM ... T) TEMP
 WHERE TEMP.SEQ < 11;
或
SELECT *
  FROM (SELECT ROW_NUMBER() OVER(ORDER BY ...) SEQ, T.*
          FROM ... T) AS TEMP
 WHERE TEMP.SEQ < 11;
Global site tag (gtag.js) - Google Analytics