How to work with basic SELECT Statements - Oracle PL SQL Course - Lesson 3 | SQL courses

Duration: 24:00 min

Summary: The SELECT is the most important SQL statement. It allows the user to read data and format report according to requirements to answer business questions. This video shows the basic syntax of the SELECT statement with the FROM clauses. The examples demonstrate how to specify several columns, how to rename a column (use of an alias), how to perform operation that manipulate columns (append and sum values), and how to eliminate duplicate values with the DISTINCT clause. The examples are executed on the HR sample database provided by Oracle and an Entity Relationship diagram is shown in the video in order to help the understanding of how the SELECT statements works.