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.
Here, column1Name, column2Name are the values of the table you want to fetch from the database.
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
Want More SQL Deep Dives