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 maximum 10 rows from a table
sql/select.1657270644.txt.gz · Last modified: 2022/07/08 08:57 by 185.92.25.28