SELECT Command

The SELECT Command

SELECT * FROM students;            -- all columns
SELECT name, marks FROM students; -- specific columns

With Conditions

SELECT name, marks FROM students
WHERE marks >= 90;

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.

SELECT Command

SELECT * FROM students;            -- सभी columns
SELECT name, marks FROM students; -- specific columns

Conditions के साथ

SELECT name, marks FROM students
WHERE marks >= 90;

Results Sort करना

SELECT name, marks FROM students
ORDER BY marks DESC;

सारांश

• SELECT * = सभी columns; specific के लिए columns list करें।
• WHERE filter करता है, ORDER BY sort करता है।