Transcript Capabilities of SQL SELECT Statements SQL SELECT STATEMENT

BASIS DATA I/2009-GENAP
SQL SELECT STATEMENT
Oleh
Satrio Agung Wicaksono, S.Kom., M.Kom
13 April 2015
BASIS DATA I/2009-GENAP
1
SQL SELECT STATEMENT
Objective
•
•
13 April 2015
List the capabilities of SQL SELECT
statements
Execute a basic SELECT statement
BASIS DATA I/2009-GENAP
2
SQL SELECT STATEMENT
Capabilities of SQL SELECT Statements
Projection
Selection
Table 1
Table 1
Join
Table 1
13 April 2015
Table 2
BASIS DATA I/2009-GENAP
3
SQL SELECT STATEMENT
Basic SELECT Statement
SELECT *|{[DISTINCT] column|expression [alias],...}
FROM
table;
•
•
SELECT identifies the columns to be displayed
FROM identifies the table containing those
columns
13 April 2015
BASIS DATA I/2009-GENAP
4
SQL SELECT STATEMENT
Selecting All Columns
SELECT *
FROM
departments;
13 April 2015
BASIS DATA I/2009-GENAP
5
SQL SELECT STATEMENT
Selecting Specific Columns
SELECT department_id, location_id
FROM
departments;
13 April 2015
BASIS DATA I/2009-GENAP
6
SQL SELECT STATEMENT
Writing SQL Statements
•
•
•
•
•
13 April 2015
SQL statements are not case-sensitive.
SQL statements can be on one or more lines.
Keywords cannot be abbreviated or split
across lines.
Clauses are usually placed on separate lines.
Indents are used to enhance readability.
BASIS DATA I/2009-GENAP
7
SQL SELECT STATEMENT
Arithmetic Expressions
Operator
13 April 2015
Description
+
Add
-
Subtract
*
Multiply
/
Divide
BASIS DATA I/2009-GENAP
8
SQL SELECT STATEMENT
Using Arithmetic Operators
SELECT last_name, salary, salary + 300
FROM
employees;
…
13 April 2015
BASIS DATA I/2009-GENAP
9
SQL SELECT STATEMENT
Operator Precedence
SELECT last_name, salary, 12*salary+100
FROM
employees;
…
SELECT last_name, salary, 12*(salary+100)
FROM
employees;
…
13 April 2015
BASIS DATA I/2009-GENAP
10
PENUTUP
Terima kasih
13 April 2015
BASIS DATA I/2009-GENAP
11