Differences

This shows you the differences between two versions of the page.

--- sql:select [2022/07/08 08:38] – created 185.192.71.135
+++ sql:select [2022/07/08 09:12] (current) – 185.92.25.28
@@ Line 4: / Line 4: @@
 <code sql>
-SELECT * from Students;
+SELECT * FROM Students;
 </code>
 ----
+===== Fetch maximum 10 rows from a table =====
+<code sql>
+SELECT fname, lname FROM Students
+LIMIT 10;
+</code>
 ----
-[[SQL:SELECT:Fetch all data from a table|Fetch all data from a table]]
+===== Fetch specific columns from a table =====
-[[SQL:SELECT:Fetch maximum 10 rows from a table|Fetch maximum 10 rows from a table]]
+<code sql>
+SELECT fname, lname FROM Students;
+</code>
-[[SQL:SELECT:Fetch selected columns from a table|Fetch selected columns from a table]]
+----
+===== 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>
+----
-[[SQL:SELECT:Filter data from a table|Filter data from a table]]