Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== SQL - SELECT ======

===== Fetch all data from a table =====

<code sql>
SELECT * FROM Students;
</code>

----

===== Fetch maximum 10 rows from a table =====

<code sql>
SELECT fname, lname FROM Students
LIMIT 10;
</code>

----

===== Fetch specific columns from a table =====

<code sql>
SELECT fname, lname FROM Students;
</code>

----

===== Filter data from a table =====

<code sql>
SELECT fname, lname FROM Students
WHERE rollno > 1234;
</code>


----

===== Fetch from two tables =====

<code sql>
SELECT fname, lname FROM Students
INNER JOIN Teachers
ON Students.teacher = Teacher.no
</code>

----

===== Fetch maximum age from a table =====

<code sql>
SELECT MAX(age)
FROM Students;
</code>

----

===== Fetch minimum age from a table =====

<code sql>
SELECT MIN(age)
FROM Students;
</code>

----

===== Fetch sum of ages from a table =====

<code sql>
SELECT SUM(age)
FROM Students;
</code>

----

===== Fetch average age from a table =====

<code sql>
SELECT AVG(age)
FROM Students;
</code>

----

===== Fetch average age for each gender =====

<code sql>
SELECT AVG(age)
FROM Students
GROUP BY gender;
</code>

----