数据库常用搜索命令(个人整理).docxVIP

— PAGE \* Arabic 1 — 数据库常用搜索命令(个人整理) select * from user_tables; select * from Employees;select commission_pct from employees;select first_name,email,job_id from employees;select department_name,department_id from departments;/* 查询多条字段时需要在中间加上“，”号。*/select first_name,last_name from employees where salaryselect salary*12 from employees;/* 所要查询的字段后可以跟上运算式进行运算查询。*/select fankl||last_name from employees;/* 添加自定义的字符串。格式：xxx|| */select * from employees where first_name||last_name=DavidAustin;/* 字段的拼接。全称是“David Austin”的信息。*/select fankl||last_name username from employees;/* 更改显示的表头的名称。字段后加“自定义的名称”或加“as+自定义的名称” */select salary*12*(1+commission_pct) from employees;select salary*12*(1+nvl(commission_pct,0)) from employees;select salary*12*(1+nvl(commission_pct,0)) as finallysalary from employees;/* （nvl）当一个字段中含有null值，需用nvl自定义一个数值，否则，这个数值最后取值依旧是null。null在数据库中代表无限大。另：nvl中的自定义内容，不仅仅是数值，还可以是日期等其它内容。 */select department_id from employees;select distinct department_id from employees;select distinct department_id,first_name from employees;/* （distinct） 字段去重。后若跟多列，则所有的都要一样才能执行。如：employees中的department_id、first_name都一样时才能进行去重。*/select salary from employees where salary10000;select * from employees where salary10000;select salary as money from employees where money10000;/* （结果为FALSE。先执行where,而表中无money一项）where的执行在select之前。*/select last_name from employees;select * from employees where department_id=30 and salary5000;select department_id,salary from employees where department_id=30 or salary5000;/* 逻辑关系操作：and、or、not。*/select first_name from employees;select salary from employees where first_name=David;/* 查询特定的内容时需要有单引号，并区分大小写。如：特定的名称。*/select salary,first_name from employees where salary5000 and salary10000;select salary,first_name from employees where salary between 5000 and 10000;select first_name,department_id from employees where department_id=60 or department_id=70 or department_id=90;select first_name,department_id from