YouTip

SQL Tutorial - Basic Queries

📅 2026-06-12 | 📂 SQL

SQL Basics

SELECT * FROM users;
SELECT name, age FROM users WHERE age > 18;
SELECT * FROM users ORDER BY name ASC;
SELECT * FROM users LIMIT 10 OFFSET 0;

WHERE Clauses

WHERE age = 25
WHERE age != 25
WHERE age BETWEEN 18 AND 30
WHERE name LIKE "A%"
WHERE city IN ("SG", "TK")
WHERE email IS NOT NULL

Summary

SELECT retrieves data from tables
WHERE filters rows, ORDER BY sorts results