SELECTING DATA
If I want to analyze my data, for example considering I own a grocery shop, I want to find out the total products sold by me, I can make use of a simple SELECT Statement.
The select statement in SQL is used to ask the database for a specific set of information.
SYNTAX

Here, column1Name, column2Name are the values of the table you want to fetch from the database.
EXAMPLE
If I want to fetch the entire content of the table, then I can use the following syntax:

Here we are using a "*" to select all columns.

Figure 15.1. Select * from Table_Name
-
If I want to analyze only the product prices, then the following Query can be used:

Figure 15.2. Analyzing the Product prices
PRACTICE YOURSELF

Want More SQL Deep Dives