
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)];


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 '_';
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 认证考试 PPT讲义Oracle OCP SQL Introduction to Oracle9i SQL 认证考试 PPT讲义隐藏>> Introduction to Oracle9i: SQL...
Introduction to Oracle9i: SQL Electronic Presentation 40049GC11 Production 1.1 October 2001 D33996 Copyright ? Oracle Corporation, 2001. All rights reserved....
Oracle9i-SQL-20 Oracle9i... 22页 免费 Introduction to Oracle9i... 暂无评价 41页 免费 Introduction to Oracle9i... 76页 5财富值 Oracle OCP SQL Introduct...
Introduction to Access S... 暂无评价 51页 免费 An Introduction to SQL I... 暂无评价 23页 免费 Introduction to Oracle9i... 76页 5财富值 Introduction...
Introduction to Access S... 暂无评价 51页 免费 An Introduction to SQL I... 暂无评价 23页 免费 Introduction to Oracle9i... 76页 5财富值 Introduction...
Exam# 1Z0-007: Introduction to Oracle9i: SQL? Writing Basic SQL Select Statements [ ] List the capabilities of SQL SELECT statements [ ] Execute a bas...
表1-3 Oracle9i Certified Associate 考试概况 考试号 1Z0-007 考试内容 Introduction to Oracle9i:SQL 1Z0-031 Oracle9i Database : Fundamentals I 44 60 73% ...
SQL Group FunctionsSQL Group Functions隐藏>> SQL Group Functions Introduction to Oracle9i: SQL 1 Chapter Objectives ? Differentiate between single-row and mult...
Introduction to Oracle9i: SQL I-5 Oracle9i Database Object Relational Data Documents XML Multimedia Messages I-6 Copyright ? Oracle Corporation, 2001. All ...
热门文档