0% found this document useful (0 votes)
5 views47 pages

02 Query Data Select

Uploaded by

Aishwarya Mishra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
5 views47 pages

02 Query Data Select

Uploaded by

Aishwarya Mishra
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 47

SQL COMPONENTS

Baraa Khatib Salkini


SQL Course | SELECT Query
-- Retrieve Customers Data
SELECT
name,
LOWER(country)

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


SQL STATEMENT

-- Retrieve Customers Data


SELECT
name,
LOWER(country)

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


Comment -- Retrieve Customers Data
SELECT
name,
LOWER(country)

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
Clauses LOWER(country)

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
Keywords LOWER(country)

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
Function
LOWER(country)

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
LOWER(country) identifiers

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
LOWER(country) Operator

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


-- Retrieve Customers Data
SELECT
name,
LOWER(country) Value

FROM customers
WHERE country = 'Italy'

Baraa Khatib Salkini| SQL Course | SELECT Query |SQL Components


QUERY DATA
SELECT STATEMENT

Baraa Khatib Salkini


SQL Course | SELECT Query
Types
SQL Commands

DQL DDL DML


Data Query Data Definition Data Manipulation
Language Language Language

SELECT CREATE INSERT

DROP UPDATE

ALTER DELETE

Baraa Khatib Salkini| SQL Course | SELECT Query


Types
SQL Commands

DQL DDL DML


Data Query Data Definition Data Manipulation
Language Language Language

SELECT CREATE INSERT

DROP UPDATE

ALTER DELETE

Baraa Khatib Salkini| SQL Course | SELECT Query


Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini| SQL Course | SELECT Query
Baraa Khatib Salkini| SQL Course | SELECT Query | SELECT ALL
Baraa Khatib Salkini|SQL Course | SELECT Query | SELECT ALL
Baraa Khatib Salkini|SQL Course | SELECT Query | SELECT Few Columns
Baraa Khatib Salkini|SQL Course | SELECT Query | SELECT Few Columns
Baraa Khatib Salkini|SQL Course | SELECT Query | WHERE
Baraa Khatib Salkini|SQL Course | SELECT Query | WHERE
Baraa Khatib Salkini|SQL Course | SELECT Query | ORDER BY
Baraa Khatib Salkini|SQL Course | SELECT Query | ORDER BY
Baraa Khatib Salkini|SQL Course | SELECT Query | ORDER BY
Baraa Khatib Salkini|SQL Course | SELECT Query | GROUP BY
Baraa Khatib Salkini|SQL Course | SELECT Query | GROUP BY
Baraa Khatib Salkini|SQL Course | SELECT Query | HAVING
Baraa Khatib Salkini|SQL Course | SELECT Query | HAVING
Baraa Khatib Salkini|SQL Course | SELECT Query | HAVING
Baraa Khatib Salkini|SQL Course | SELECT Query | DISTINCT
Baraa Khatib Salkini|SQL Course | SELECT Query | DISTINCT
Baraa Khatib Salkini|SQL Course | SELECT Query | TOP
Baraa Khatib Salkini|SQL Course | SELECT Query | TOP
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
BONUS
Sketches

Baraa Khatib Salkini


SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query
Baraa Khatib Salkini|SQL Course | SELECT Query

You might also like