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