SQL is a database language. It gets the information from the given tables. Table is the place from where we get our data. There are two main words which are used in the structure of SQL. These are ‘Select’ and ‘From’.
The structure of SQL is given here:
In order to explain the structure, here is an example for you:
San Francisco $1200 Jan-08-2011
Boston $230 Jan-08-2011
San Diego $350 Jan-09-2011
Los Angeles $770 Jan-09-2011
In order to put all the information related to all stores, we have gathered all the data.
It is possible for you to select many columns at a time. You can also select many table names.