Learning Center
Learning Center
  • HTML
  • CSS
  • JAVASCRIPT
  • Bootstrap
  • React
  • jQuery
  • NodeJs
  • Sql
  • MySql
  • Python
  • OpenVPN Setup
  • Log In
Coding Choice Home About Contact ☰

  1. You are here
  2. Home
  3. sql
  4. querying_data

Sidebar
  • Introduction
  • Getting Started
  • Querying Data
  • Joins
  • Stored Procedures
  • Transactions
  • Database Security
  • SQL Optimization
  • Share via
    • Share via...
    • Twitter
    • LinkedIn
    • Facebook
    • Pinterest
    • Telegram
    • WhatsApp
    • Yammer
    • Reddit
    • Teams
  • Send via e-Mail
  • Print
  • Permalink

Querying Data

SELECT Statement

Retrieves data from a table.

SELECT name, salary FROM employees;

WHERE Clause

Filters records based on a condition.

SELECT * FROM employees WHERE department = 'HR';

ORDER BY Clause

Sorts query results.

SELECT * FROM employees ORDER BY salary DESC;