Tugas Basis Data I ( Praktikum 6 )

Gambar 1

Support Operators

 Gambar 2

Error generated by undened function or type combination

 Gambar 3

Error generated by undened operator or type combination

 Gambar 4

Large Objects (BLOBs)

 Gambar 5

 Subqueries can replace some joins

Gambar 6

Correlated subquery

Gambar 7

NOT IN and Subqueries with NULL Values

Gambar 8

Customers who have no orders

Gambar 9

IN query rewritten using ANY and EXISTS

Gambar 10

NOT IN query rewritten using ALL and EXISTS

Gambar 11

Simulating outer joins

Gambar 12

Subqueries with UPDATE and DELETE

Gambar 13

Table creation with SELECT

TUGAS BASIS DATA I

         Praktikum 6

Nama   :  Eka Agusti Ningsih

Kelas    :  1 B / Teknik Informatika

NPM     :  1103058

Tugas Basis Data I ( Praktikum 5 )

SQL AGGREGATES

Gambar 1

Examples of Aggregates

Gambar 2

Aggregates and NULL values

Gambar 3

 Aggregate with GROUP BY

Gambar 4

GROUP BY with two columns

Gambar 5

Combining SELECTs

Gambar 6

Combining two tables with UNION

Gambar 7

UNION with duplicates

Gambar 8

 UNION ALL with duplicates

Gambar 9

INTERSECT returns only duplicated rows

Gambar 10

EXCEPT restricts output from the First SELECT

Gambar 11

Subqueries: Friends not in Dick Gleason's state

Gambar 12

Subqueries can replace some joins

Gambar 13

Correlated subquery

Gambar 14

NOT IN and Subqueries with NULL Values

Gambar 15

Customers who have no orders

Gambar 16

IN query rewritten using ANY and EXISTS

Gambar 17

Simulating outer joins

Gambar 18

Subqueries with UPDATE and DELETE

Gambar 19

Table creation with SELECT

TUGAS BASIS DATA I

          Praktikum 5

Nama   :  Eka Agusti Ningsih

Kelas    : 1 B / Teknik Informatika

NPM    :  1103058

Tugas Basis Data I ( Praktikum 4 )

Perintah Dasar SQL

 Gambar 1

Numbering Rows

 Gambar 2

Contoh Penggunaan Sequence

 Gambar 3

 The customer table using serial

 Gambar 4

Combining SELECTs

Gambar 5

Combining two tables with UNION

UNION with duplicates

Gambar 6

UNION ALL with duplicates

Reverse Order By

Menggunakan Order By dan Where

Gambar 7

NULL Handling

Gambar 8

NULL Handling (2)

Gambar 9

NULL Handling (3)

Gambar 10

Collum Label

 Gambar 11

Membuat Teman Baru

Gambar 12

Menggunakan AND dan OR

 Gambar 13

Menggunakan AND dan OR (2)

 Gambar 14

 Range of Values

 Gambar 15

LIKE Comparison

Gambar 16

CASE Clause

Gambar 17

CASE Clause (2)

Gambar 18

CASE Clause (3)

Gambar 19

CASE Clause Example

Gambar 20

Distinct Row

Gambar 21

DISTINCT prevents duplicates

Gambar 22

Functions and Operators

Gambar 23

Functions and Operators

Gambar 24

Operator examples

Gambar 25

Date Style

TUGAS BASIS DATA I

         Praktikum 4

Nama   :  Eka Agusti Ningsih

Kelas    :  1 B / Teknik Informatika

NPM     :  1103058