CRUD Operations
SELECT Statements
Retrieving Data
💡 SELECT, EK, "SEARCH, REQUEST" hai — TUM, BATATE, HO, ki, KAUN, se, COLUMNS, (FIELDS) aur, KAUN, si, TABLE, (SOURCE) se, DATA, chahiye, aur, DATABASE, MATCHING, results, RETURN, karta hai.
SELECT * FROM table_name, SAARE, COLUMNS, RETURN, karta hai — SPECIFIC, columns, (SELECT name, email FROM users) sirf, ZAROORI, DATA, RETURN, karke, PERFORMANCE, improve, karte, HAIN.
LIMIT, results, ki, COUNT, RESTRICT, karta hai. ORDER BY, results, ko, SORT, karta hai (ASC, default, YA, DESC).
SELECT name, email FROM users
WHERE age > 18
ORDER BY name ASC
LIMIT 10;🔎
SELECT, EK, "SEARCH, REQUEST" hai — TUM, BATATE, HO, ki, KAUN, se, COLUMNS, (FIELDS) aur, KAUN, si, TABLE, (SOURCE) se, DATA, chahiye, aur, DATABASE, MATCHING, results, RETURN, karta hai.
1 / 2
⚡ झट से Recap
- SELECT * = saare columns, SELECT col1, col2 = specific columns
- LIMIT = results, ki, count, restrict, karta hai
- ORDER BY = results, ko, sort, karta hai
इस page में (2 subtopics)
SELECT DISTINCT, DUPLICATE, rows, ko, results, se, REMOVE, kar, deta hai — jaise, EK, orders, table, se, SIRF, UNIQUE, customer, cities, ki, list, chahiye.
SELECT DISTINCT city FROM customers;AS, keyword, se, COLUMNS, (ya, computed, expressions) ko, EK, ALIAS, (alternate, naam) diya, ja, sakta hai — output, ko, MORE, readable, banaта, hai, ESPECIALLY, computed, columns, ke, liye.
Tip: AS, keyword, TECHNICALLY, OPTIONAL, hai (SELECT price AS p, SELECT price p, dono, kaam, karte, HAIN), LEKIN, explicit, AS, use, karna, readability, ke, liye, BEHTAR, practice, hai.