MySQL + SQL · Lesson 44

SELECT Command

The SELECT Command

SELECT retrieves data from tables. It is the most used SQL command.
SELECT * FROM students;            -- all columns
SELECT name, marks FROM students; -- specific columns

With Conditions

SELECT name, marks FROM students
WHERE marks >= 90;
Returns only students scoring 90 or more.

Sorting Results

SELECT name, marks FROM students
ORDER BY marks DESC;

Summary

  • SELECT * = all columns; list columns for specific ones.
  • WHERE filters, ORDER BY sorts.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.