Explanation

SQL (Structured Query Language) is used to work with data stored in relational databases.

SQL can be used to:

  • Retrieve data
  • Filter records
  • Sort records
  • Group data
  • Join tables
  • Calculate summaries
  • Insert/update/delete data

Basic SQL Query

SELECT *

FROM Sales;

This returns all columns and rows from the Sales table.

Select Specific Columns

SELECT OrderID, CustomerID, SalesAmount

FROM Sales;

Filter Data

SELECT *

FROM Sales

WHERE City = ‘Sirsa’;

Sort Data

SELECT *

FROM Sales

ORDER BY SalesAmount DESC;

Practice

Write SQL queries to retrieve:

  1. All sales
  2. Sales from Sirsa
  3. Sales greater than ₹50,000
  4. Highest sales first
PreviousNext