BASIS DATA 1, MODUL BAB 6

BHAYANG RATU WAHYUNUR [1103051]
TI. 1B

Large Objects

 Support Operator

 Type Combination 1

Type Combination 2

 Using select and insert

Sub query update delete

Simulating Outer

 Not in query

 In query

Customer

Not in

 Corellated Sub query

 Sub query can replace

BASIS DATA 1 MODUL BAB 4 dan BAB 5

BHAYANG RATU WAHYUNUR [1103051]
T.I 1B

TUGAS MODUL BAB 4

Case Clause Examples

Case Clause

Case Clause 2

 Case Clause 3

Coloum Label

Combining Select

Combining Two Tables With UNION

Contoh Squence

Contoh Squence 2

Date Style

DISTINCT prevents duplicates

DISTINCT Row

Fungtion and Operator

Fungtion and Operator 1

Fungtion and operator 2

Like Comparison

Membuat teman baru

Menggunakan AND dan OR

 Menggunakan AND dan OR 2

Menggunakan ORDER BY dan WHERE

NULL handling

 NULL handling 2

 NULL handling 3

Numbering

 Range of VALUES

 Reverse Order

 The Customer table using

UNION all with DUPLICATES

UNION duplicates

TUGAS MODUL BAB 5

 Combining Select

 Combining Two With Union

 EXCEPT and INTERSECT

 Subqueries Friends not in dick

UNION with duplicates

BASIS DATA 1 : SQL AGGREGATES and JOINING TABLE

Posted by Bhayang Ratu Wahyunur
Teknik Informatika 1 B
Pertemuan 3

Aggregates

Aggregates 2

Using Group by

Using Having

Aggregates Null and Values

Group By With Two Columns

Joining Table

Creation Of Company Table

Insertion of Company Table

Finding a Costumer name using two queries

Finding a customer name using one query and 

Finding an order number for a customer name

Three table join

Employees who have taken orders for customer

Joining customer and employee

Joining part and employee

The statement table

Choosing a join key

One to many join

Unjoinned Table