Looking for a Tutor Near You?

Post Learning Requirement »
x

Choose Country Code

x

Direction

x

Ask a Question

x

x
x
x
Hire a Tutor

PPT On Extracting Data

Loading...

Published in: PHP And MySQL | PL/SQL
84 Views

To analyze the data, we have to extract it from various sources. The PPT gives a clear example of how to extract the data using the SELECT CLAUSE and the output gives the indication of the result extracted.

Mohammed A / Hyderabad

7 years of teaching experience

Qualification: Masters in Engineering

Teaches: Business Analytics, PL/SQL, Tableau, Python Programming

Contact this Tutor
  1. 1 2 3 select * from ustomers; The Line of Code is written to call the table With the name 'customers'. SELECT is SQL Keyword FROM is SQL Kevv'ord customers is a variable *' is used to call entire table is used to terminate an SQL code This is the result grid, which gets the output in accordance with the SQL code the the
  2. 4 6 7 8 9 select first name, age, f rom customers ; country SQL code is written To call specific columns From a Table, unlike the previous slide, where all columns is called. Here only first_name,age & country are called Output in accordance with SQL Code