Linux it SQL Declaration Concise Tutorial---WHERE

We don't necessarily have to notice that each time the information inside the lattice is completely stuck. In many cases, we need to selectively capture data. For our samples. We can just grab a turnover over $1,000 contour.

To do this, we need to use the where command. 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 form below,

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 Real results:


Reprint Please specify: Liu

Copyright notice: This article blog original articles, blogs, without consent, may not be reproduced.

Linux it SQL Declaration Concise Tutorial---WHERE