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 selected 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.1657269722.txt.gz · Last modified: 2022/07/08 08:42 by 185.192.71.135