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