modul praktikum 6

BASDAT

0

Continue Reading

TUGAS MODUL 4 BASIS DATA

SEQUENCE

 

TABEL CUSTOMER

INSERT TABEL CUSTOMER

TABEL FRIEND

TABEL TERRESTRIAL_ANIMAL

TABEL AQUATIC_ANIMAL

SELECT FRIEND

SELECT FRIEND

TABEL NULLTEST

SELECT TABEL FRIEND

COMMENT

TABEL OIDTEST

DELETE FRIEND

SELECT FRIEND

SELECT FRIEND

SELECT FRIEND

SELECT FRIEND

SELECT FRIEND

SELECT FRIEND

SELECT FRIEND

DF FUNCTION

SQRT DAN DO

\DO /

\DO ^

DATESTYLE

0

Continue Reading

tugas modul 3 basis data

Aggregates

Using GROUP BY

Using HAVING

Aggregates and NULL values

GROUP BY with two columns

JOINING TABLES

Creation of company tables

Insertion into company tables

Finding a customer name using two queries

Finding an order number for a customer name

Three-table join

Four-table join

Employees who have taken orders for customers

Joining customer and employee

Joining customer and employee

0

Continue Reading