A concise tutorial of SQL statements for Linux---WHERE

We do not necessarily have to completely grasp the information in the form every time. In many cases, we will need to selectively capture information. In our case, we may just have to pick up more information than $1,000. To do this, we need to use the where directive. The syntax for this instruction is as follows:

Select "Field name"
From "Table name"
WHERE "condition";

If we want to capture the information of turnover exceeding $1,000 by the following form,

store_information Form

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

We'll break in,

SELECT Store_name
From Store_information
WHERE Sales >;

Results:

Store_name

Los Angeles

Linux measured results:


Reprint please specify: Xiao Liu

A concise tutorial of SQL statements for Linux---WHERE