659441806 发表于 2016-11-14 08:19:12

db2基本学习资料参考链接

  http://blog.csdn.net/jarvis_java/article/category/589260
  http://blog.csdn.net/jarvis_java/article/details/5956974  DB2字段类型 图文并茂
  DB2 只查询前10行 fetch first 10 rows only

例如:

SELECT
SALE_DATE,
SUM(SALE_MONEY) AS SUM_MONEY
FROM
SALE_REPORT
GROUP BY
SALE_DATE
ORDER BY
SUM(SALE_MONEY) DESC
fetch first 10 rows only;
页: [1]
查看完整版本: db2基本学习资料参考链接