SQL SELECT
This statement is used to fetch the rows from the database table. Data is returned in the form of result table, which are also know as result-sets.
Syntax:
SELECT coulmn1, column2, .... , column N FROM table_name;
Above statement will show all the rows with columns specified in SELECT query from “table_name” table.
OR
SELECT * FROM table_name;
Above statement will select all columns/rows in “table_name” table.
*(asterik) : is used to retrieve all the columns from specified table.