Praktikum 6

1. Membuat tabel array_test

2. Insert data array_tes dan select * from array_test;

3. Select col1[4] from array_test;

4. Select col2[2][1] from array_test;

5. Select col3[1][2][2] from array_test;

 6. Hasil nama customer

7. Hasil nama customer

8.  Correlated subquery

9. Correlated subquery

10. NOT IN and Subqueries with NULL Values

11. NOT IN and Subqueries with NULL Values

12. NOT IN and Subqueries with NULL Values

13. NOT IN and Subqueries with NULL Values

14. NOT IN and Subqueries with NULL Values

15. NOT IN and Subqueries with NULL Values

 16. NOT IN query rewritten using ALL and EXISTS

17. NOT IN query rewritten using ALL and EXISTS

18. NOT IN query rewritten using ALL and EXISTS

19. Simulating outer joins

20. Subqueries with UPDATE and DELETE

21. Subqueries with UPDATE and DELETE

22. Subqueries with UPDATE and DELETE

23. Using SELECT with INSERT

24. Table creation with SELECT

25. Table creation with SELECT

Read More...

Praktikum 4

1. Membuat tabel oidtest

2. Membuat sequence customer_seq; setekag itu membuat tabel customer, Insert data customer dan untuk melihat hasil nya select * from customer;

 

3. Membuat tabel customer_id SERIAL

4. Untuk melohat hasilnya \d customer table "customer"

5. Insert customer dan select * from customer;

 6. Membuat tabel terrestrial_animal, membuat tabel aquatic_animal, insert data terrestrial_animal dan aquatic_animal dan untuk hasilnya select name from aquatic_animal UNION select name from terrestrial_animal;

7. Insert aquatic_animal dan terrestrial_animal dan untuk melihat hasilnya select name from aquatic_animal UNION select name from terrestrial_animal;

 8. Insert data friend dan untuk melihatnya select * from friend;

 9. Select * from friend ORDER BY state;

 10. Select * from friend ORDER BY age DESC;

 11. Select * from friend where age )=21 ORDER BY firstname;

 12. Select * from friend wheer age ) 0 ORDER BY age DESC;

13. Select * from friend where age <> 99 ORDER BY age DESC;

1

 14. Select * from friend where age is NULL ORDER BY age DESC;

 15. Insert friend dan select * from friend where city = state;

 16. Membuat tabel nulltest, Insert data nulltest dan select * from nulltest ORDER BY name;

17. Select * from nulltest where spouse = ' ';

18. Select * from nulltest where spouse is null;

19. Membuat tabel account

20. Insert data account dan select * from account;

 21. Membuat teman baru

22. Select * from friend ORDER BY firstname;

 23. Select * from friend where firstname = 'Sandy' and lastname = ' Gleason';

 24. Select * from friend where state = 'NJ' or state = 'PA' ORDER BY firstname;

25.  Select * from friend where firstname= 'Victor' and state = 'PA' or state = 'NJ' ORDER BY firstname;

26. Select * from friend where firstname = 'Victor' and state = 'PA' or state = 'NJ' ORDER BY firstname;

Read More...