1.
SELECT Statement
Used to retrieve data from a table.
Syntax:
sql
Copy code
SELECT column1, column2 FROM table_name;
Example:
sql
Copy code
SELECT Name, Marks FROM Student;
✅ 2. SELECT * (All Columns)
Retrieves all columns from the table.
Syntax:
sql
Copy code
SELECT * FROM table_name;
Example:
sql
Copy code
SELECT * FROM Student;
✅ 3. WHERE Clause
Filters rows based on a condition.
Syntax:
sql
Copy code
SELECT column1 FROM table_name WHERE condition;
Example:
sql
Copy code
SELECT Name FROM Student WHERE Marks > 80;
✅ 4. DISTINCT Keyword
Removes duplicate values.
Syntax:
sql
Copy code
SELECT DISTINCT column_name FROM table_name;
Example:
sql
Copy code
SELECT DISTINCT Grade FROM Student;
✅ 5. ORDER BY Clause
Sorts the result in ascending (ASC) or descending (DESC) order.
Syntax:
sql
Copy code
SELECT column1 FROM table_name ORDER BY column1 ASC|DESC;
Example:
sql
Copy code
SELECT Name, Marks FROM Student ORDER BY Marks DESC;
✅ 6. IN Operator
Checks if a value matches any value in a list.
Syntax:
sql
Copy code
SELECT column1 FROM table_name WHERE column_name IN (value1, value2);
Example:
sql
Copy code
SELECT Name FROM Student WHERE Grade IN ('A', 'B');
✅ 7. BETWEEN Operator
Checks if a value is within a range.
Syntax:
sql
Copy code
SELECT column1 FROM table_name WHERE column_name BETWEEN value1 AND value2;
Example:
sql
Copy code
SELECT Name FROM Student WHERE Marks BETWEEN 70 AND 90;
✅ 8. LIKE Operator
Used for pattern matching with % and _.
Syntax:
sql
Copy code
SELECT column1 FROM table_name WHERE column_name LIKE 'pattern';
Example:
sql
Copy code
SELECT Name FROM Student WHERE Name LIKE 'A%'; -- Names starting with A
✅ 9. IS NULL Operator
Checks for NULL values.
Syntax:
sql
Copy code
SELECT column1 FROM table_name WHERE column_name IS NULL;
Example:
sql
Copy code
SELECT Name FROM Student WHERE Grade IS NULL;
✅ 10. Logical Operators (AND, OR, NOT)
Combine multiple conditions.
Syntax:
sql
Copy code
SELECT column1 FROM table_name WHERE condition1 AND/OR/NOT condition2;
Example:
sql
Copy code
SELECT Name FROM Student WHERE Marks > 80 AND Grade = 'A';
