💾 SQL Practice Answers – Part 2(Basic Level)

SQL Practice Questions – Part 2 (Answers)


🔹 Answer 11 – Select Multiple Columns



SELECT name, age FROM students;


🔹 Answer 12 – Greater Than Condition



SELECT * FROM students

WHERE age > 18;


🔹 Answer 13 – Less Than Condition



SELECT * FROM students

WHERE age < 18;


🔹 Answer 14 – AND Condition



SELECT * FROM students

WHERE age = 17 AND name = 'Santhosh';


🔹 Answer 15 – OR Condition



SELECT * FROM students

WHERE age = 17 OR age = 19;


🔹 Answer 16 – Order By Ascending



SELECT * FROM students

ORDER BY age ASC;


🔹 Answer 17 – Order By Descending



SELECT * FROM students

ORDER BY age DESC;


🔹 Answer 18 – Count Records



SELECT COUNT(*) FROM students;


🔹 Answer 19 – Maximum Age



SELECT MAX(age) FROM students;


🔹 Answer 20 – Minimum Age



SELECT MIN(age) FROM students;


Kalvi Vaanam Note:
WHERE, ORDER BY, மற்றும் Aggregate functions SQL-ல் மிகவும் முக்கியமான concepts 👍

Comments

Popular Posts