20 April 2011

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

No comments :

Post a Comment