💾 SQL Practice Answers – Part 3(Basic Level)

SQL Practice Questions – Part 3 (Answers)

---

🔹 Answer 21 – Insert Multiple Records

INSERT INTO students (id, name, age)

VALUES 

(1, 'Santhosh', 16),

(2, 'Arun', 17),

(3, 'Kumar', 15);

---

🔹 Answer 22 – Update Record

UPDATE students

SET age = 18

WHERE name = 'Santhosh';

---

🔹 Answer 23 – Delete Specific Record

DELETE FROM students

WHERE name = 'Arun';

---

🔹 Answer 24 – Delete All Records

DELETE FROM students;

---

🔹 Answer 25 – Drop Table

DROP TABLE students;

---

🔹 Answer 26 – Select Distinct Values

SELECT DISTINCT name

FROM students;

---

🔹 Answer 27 – Between Condition

SELECT *

FROM students

WHERE age BETWEEN 15 AND 18;

---

🔹 Answer 28 – LIKE Operator

SELECT *

FROM students

WHERE name LIKE 'S%';

---

🔹 Answer 29 – IN Operator

SELECT *

FROM students

WHERE age IN (15, 17, 19);

---

🔹 Answer 30 – NOT Condition

SELECT *

FROM students

WHERE age != 18;

---

Kalvi Vaanam Note:
SQL Database control செய்ய INSERT, UPDATE, DELETE, SELECT conditions concepts மிகவும் முக்கியம் 👍