Scribd
Upload
15 views1 page

SQL Syllabus with Examples

The document provides a complete SQL syllabus with examples, focusing on the syntax and structure of SQL queries. It includes an example of retrieving employee names and salaries above 70,000, demonstrating the use of SELECT, FROM, WHERE, and ORDER BY clauses. The explanation clarifies the purpose of each SQL component in the query.

Uploaded by

jawarimandiofficial
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
15 views1 page

SQL Syllabus with Examples

The document provides a complete SQL syllabus with examples, focusing on the syntax and structure of SQL queries. It includes an example of retrieving employee names and salaries above 70,000, demonstrating the use of SELECT, FROM, WHERE, and ORDER BY clauses. The explanation clarifies the purpose of each SQL component in the query.

Uploaded by

jawarimandiofficial
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

Complete SQL Syllabus with Examples (Colored)

How SQL Looks Like - Syntax and Example

-- SQL Example: Retrieving employee names and salaries where salary > 70000, sorted by salary
descending

SELECT name, salary


FROM employees
WHERE salary > 70000
ORDER BY salary DESC;

-- Explanation:
-- SELECT: Columns to retrieve
-- FROM: Table to retrieve data from
-- WHERE: Condition to filter rows
-- ORDER BY: Sorts the results

You might also like