1、普通分組group by查詢

SELECT

????????"CITY_GDDWBM" AS "citygddwbm",

????????"AREA_GDDWBM" AS "areagddwbm",

????????"GDJMC" AS "gdjmc"

FROM

????????SMBH_IGS_YYTXX

WHERE

????????"CITY_GDDWBM"='0501'

GROUP BY

????????"AREA_GDDWBM","CITY_GDDWBM","GDJMC"

ORDER BY

????????"AREA_GDDWBM" ASC

這種group by分組查詢只能讓3個字段去重，多了字段的話去重無效果

2、特殊group by分組查詢

select

????????"YYTTYBM" AS "yyttybm",

????????"CITY_GDDWBM" AS "citygddwbm",

????????"AREA_GDDWBM" AS "areagddwbm",

????????"GDJMC" AS "gdjmc"

from SMBH_IGS_YYTXX where ROWID IN (

????????SELECT MIN(ROWID) FROM SMBH_IGS_YYTXX t GROUP BY t.AREA_GDDWBM

) AND "CITY_GDDWBM"='0501'

這種group by分組查詢能讓多個字段去重

3、window的oracle數據庫添加用戶并授予權限

(1)使用sqlplus進圖oracle數據庫

sqlplus / as sysdba

(2)創建新用戶

create user yyzj identified by "123456";

(3)授予權限

grant create session to yyzj;

grant create table to yyzj;

grant create tablespace to yyzj;

grant create view to yyzj;

grant dba to yyzj;

4、Oracle數據庫查看和添加索引

查看索引：select index_name from all_indexes where table_name = 'STRUCTURED_ADDRESS';

添加索引：CREATE INDEX IDX_ADDRESS_CODE ON STRUCTURED_ADDRESS(ADDRESS_CODE);

?

總結

以上是生活随笔為你收集整理的oracle数据库分组查询group by的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。