SQL statement for linux --- WHERE, where --- WHERE

SQL statement for linux --- WHERE, where --- WHERE

We do not have to capture all the information in the table every time. In many cases, we need to select materials. In our example, we may only need to capture information with a turnover of more than $1,000. To achieve this, we need to useWHEREThis command. The syntax of this command is as follows:

SELECT "column name"
FROM "table name"
WHERE "condition ";

If we want to capture information with a turnover of more than $1,000 from the following table,

Store_InformationTable

Store_Name	Sales	Txn_Date
Los Angeles	1500	05-Jan 1999
San Diego	250	07-Jan-1999
Los Angeles	300	08-Jan 1999
Boston	700	08-Jan 1999

Let's get,

SELECT Store_Name
FROM Store_Information
WHERE Sales> 1000;

Result:

Store_Name

Los Angeles

Linux test results:


Reprinted, please note: Xiao Liu