SELECT used for fetch data from a table in database.
1)-All rows and all columns
SELECT * FROM tablename;
2)-Some columns and all rows
SELECT column1,column2,column3 FROM tablename;
3)-Some rows and all columns
SELECT * FROM tablename WHERE condition;
4)-Some rows and some columns
SELECT column1,column2,column3 FROM tablename WHERE condition;
Copyright ©2022 coderraj.com. All Rights Reserved.