sql:select
This is an old revision of the document!
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
sql/select.1657271271.txt.gz · Last modified: 2022/07/08 09:07 by 185.92.25.28