ORACLE SQL 2 - SELECT STATEMENT

ORACLE SQL 2 - SELECT STATEMENT

https://github.com/hadjitejuco/oraclesql

/* Retrieve the data from our products table SELECT

select *
from products;

Retrieve Individual columns
select prod_name
from products;

Retrieve Multiple columns
select prod_id, prod_name, prod_price
from products;

Retrieve all the columns  (*)
select *
from products;

Retrieving distinct rows
DISTINCT 

select distinct vend_id
from products;

retrieve data using fully qualified table names

select products.prod_name
from products;

*/ ... https://www.youtube.com/watch?v=7UrQSTFnJcw