💾 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
Post a Comment