文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > Introduction to Oracle9i SQL
侵权投诉

Introduction to Oracle9i SQL

Introduction to Oracle9i  SQL

2-1.Limit the rows retrieved by a query 限制請求取回的列資料 2-2.Sort the rows retrieved by a query 排序請求取回的列資料

SELECT *|{[DISTINCT] column|expression [alias],...} FROM table

[WHERE condition(s)];

Introduction to Oracle9i  SQL

Introduction to Oracle9i  SQL

BETWEEN condition ( BETWEEN MIN_VALUE AND MAX_VALUE )

使用BETWEEN條件,要注意大小值放置順序,當大小反置,將不回傳回任何數值. SELECT last_name, salary FROM employees

WHERE salary BETWEEN 2500 AND 3500;

或 → WHERE salary BETWEEN 3500 AND 2500; 將沒有任何資料列被選取 ※如果MIN_VALUE與MAX_VALUE值相等,同樣沒有任何資料列被選取

IN Condition ( IN (100, 101, 201) )

SELECT employee_id, last_name, salary, manager_id FROM employees

WHERE manager_id IN (100, 101, 201); Or last_name IN ('Hartstein', 'Vargas');

凡符合(100,101,201)或('Hartstein', 'Vargas')值條件

LIKE Condition (字圖比對方式) % 包含零個或多個字元 _ 只包含一個字元

SELECT last_name FROM employees

WHERE last_name LIKE '_o%';

*從employees表單取回last_name欄位,第二位字元是o的字串.

*如果需查詢包含_字符的字串時,可用\符號. SELECT employee_id, last_name, job_id FROM employees

WHERE job_id LIKE ' %SA\_%' ESCAPE ' \ ' ; →注意要加ESCAPE \ ;

相同如果要搜尋包含SA_的字串時 →select a from b where a like '%SA\_%' ESCAPE '_';

上一页第5页

你可能喜欢

热门文档

相关文档

  • Introduction to Oracle9i SQL -__ Volume III

    Introduction to Oracle9i SQL -__ Volume III oracle认证教材oracle认证教材隐藏>> Introduction to Oracle9i: SQL Additional Practices ? Volume 3 40049GC10 Produ...

  • Oracle OCP SQL Introduction to Oracle9i SQL

    Oracle OCP SQL Introduction to Oracle9i SQL 认证考试 PPT讲义Oracle OCP SQL Introduction to Oracle9i SQL 认证考试 PPT讲义隐藏>> Introduction to Oracle9i: SQL...

  • Oracle9i-SQL

    Introduction to Oracle9i: SQL Electronic Presentation 40049GC11 Production 1.1 October 2001 D33996 Copyright ? Oracle Corporation, 2001. All rights reserved....

  • Analytic Extensions to SQL in Oracle9i

    Oracle9i-SQL-20 Oracle9i... 22页 免费 Introduction to Oracle9i... 暂无评价 41页 免费 Introduction to Oracle9i... 76页 5财富值 Oracle OCP SQL Introduct...

  • Introduction to T-SQL

    Introduction to Access S... 暂无评价 51页 免费 An Introduction to SQL I... 暂无评价 23页 免费 Introduction to Oracle9i... 76页 5财富值 Introduction...

  • 02-Introduction to SQL

    Introduction to Access S... 暂无评价 51页 免费 An Introduction to SQL I... 暂无评价 23页 免费 Introduction to Oracle9i... 76页 5财富值 Introduction...

  • Oracle9i_sql

    Exam# 1Z0-007: Introduction to Oracle9i: SQL? Writing Basic SQL Select Statements [ ] List the capabilities of SQL SELECT statements [ ] Execute a bas...

  • Oracle9i OCP考试

    表1-3 Oracle9i Certified Associate 考试概况 考试号 1Z0-007 考试内容 Introduction to Oracle9i:SQL 1Z0-031 Oracle9i Database : Fundamentals I 44 60 73% ...

  • SQL Group Functions

    SQL Group FunctionsSQL Group Functions隐藏>> SQL Group Functions Introduction to Oracle9i: SQL 1 Chapter Objectives ? Differentiate between single-row and mult...

  • ORACLE基础篇-SQL

    Introduction to Oracle9i: SQL I-5 Oracle9i Database Object Relational Data Documents XML Multimedia Messages I-6 Copyright ? Oracle Corporation, 2001. All ...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email