oracle sql语句汇总

1.建数据库用户

drop user qsxt_43 cascade;

create user qsxt_43 identified by qsxt_43 default tablespace sinitek;

grant connect,resource to qsxt_43;

2.求和 sum，count

求表数据有几条数据：select sum(1) from 表名; select count(*) from 表名;

求表中某个字段的相加总和（int，double，float型，或者只有数字的Varchar型）select sum(字段) from 表名;

返回指定列的值的数目（NULL 不计入）select count(列名) from 表名;

3.替换replace

update 表名 set 字段=replace(字段,'modules/qsxt','jsp');  --这里就把该字段下所有'modules/qsxt'替换成'jsp'

4.返回唯一不同的值distinct 

select distinct 列名 from 表名;

5.排序 order by

默认升序排列，可以加desc变为降序

SELECT * FROM Websites ORDER BY alexa DESC;

6.SELECT TOP, LIMIT, ROWNUM

SELECT TOP number|percent column_name(s) FROM table_name;

SELECT column_name(s) FROM table_name LIMIT number;

SELECT column_name(s) FROM table_name WHERE ROWNUM <= number;