sql:select
Table of Contents
SQL - SELECT
Fetch all data from a table
SELECT * FROM Students;
Fetch maximum 10 rows from a table
SELECT fname, lname FROM Students LIMIT 10;
Fetch specific columns from a table
SELECT fname, lname FROM Students;
Filter data from a table
SELECT fname, lname FROM Students WHERE rollno > 1234;
Fetch from two tables
SELECT fname, lname FROM Students INNER JOIN Teachers ON Students.teacher = Teacher.no
Fetch maximum age from a table
SELECT MAX(age) FROM Students;
Fetch minimum age from a table
SELECT MIN(age) FROM Students;
Fetch sum of ages from a table
SELECT SUM(age) FROM Students;
Fetch average age from a table
SELECT AVG(age) FROM Students;
Fetch average age for each gender
SELECT AVG(age) FROM Students GROUP BY gender;
sql/select.txt · Last modified: 2022/07/08 09:12 by 185.92.25.28