SELECTING DATA

SYNTAX | EXAMPLE | PRACTICE YOURSELF

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