What is the syntax of SELECT statement

Question

Hi!!

Can someone tell me what exactly is the SELECT statement?

Answer 1

This statement is used to select data from a database and the data returned is stored in a result table, called the result-set.

The following are the two ways of using this statement:

Syntax:

SELECT column1, column2, ...
FROM table_name;

--(*) is used to select all from the table

SELECT * FROM table_name;