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.

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *