SQL/PSQL Fundamentals - Desklib

Running head: SQL/PSQL FUNDAMENTALS
SQL/PSQL Fundamentals
Name of the student:
Name of the University:
Author note:

1
SQL/PSQL FUNDAMENTALS
Table of Contents
Task 1...............................................................................................................................................2
Task 2...............................................................................................................................................4
Task 3...............................................................................................................................................8
Task 3.............................................................................................................................................12
Task 4.............................................................................................................................................17

2
SQL/PSQL FUNDAMENTALS
Task 1
1. Creating a query (Display all customer records)
SELECT * FROM CUSTOMER;
2. Limiting the number of outputs (Display only first 2 customer records)
SELECT * FROM CUSTOMER WHERE ROWNUM <= 2;

3
SQL/PSQL FUNDAMENTALS
3. Sorting a table
Ascending Order Sort
SELECT * FROM CUSTOMER
ORDER BY CUST_ID ASC;
Descending Order sort
SELECT * FROM CUSTOMER
ORDER BY CUST_ID DSC;