Data Analysis

Skip Navigation Links.

Category List

Salt Industry

Wholesale

Crude Salt

Generate Query Query Result Help

Select column-name(s)

Add/remove field(s)

Added column(s)

Select conditional column(s)

Select condition

Select value(s)

Created query

The Custom Query module is a dynamic report generator where user can create custom report whenever required. To open Custom query, point the mouse pointer to the Data Analysis then click on the Custom Query menu.

Explanation of Conditional Operators:

= Equal to Operator
Checks if the value of two operands are equal, if yes then condition becomes true and will find data from database.
e.g. SELECT * FROM data_table WHERE zone_name = 'Dhaka' AND factory_type = 'Traditional';
The following SQL statement select only "Dhaka" zone data from "data_table" table.
≠ Not Equal to Operator
Checks if the value of two operands are not equal, if values are not equal then condition becomes true and will find data from database.
Not Equal "≠" operator can be written as "!=" or "<>"
e.g.
SELECT * FROM data_table WHERE zone_name ≠ 'Dhaka';
Or
SELECT * FROM data_table WHERE zone_name != 'Dhaka';
Or
SELECT * FROM data_table WHERE zone_name <> 'Dhaka';
The following SQL statements selects all data from "data_table" table except "Dhaka" zone.
and AND Operator
The AND operator allows the existence of multiple conditions in an SQL statement's WHERE clause.
e.g. SELECT * FROM data_table WHERE zone_name = 'Dhaka' AND factory_type = 'Traditional';
The following SQL statement select data, which has "Traditional" factory type of "Dhaka" zone from "data_table" table.
> Greater than Operator
Checks if the value of left operand is greater than the value of right operand, if yes then condition becomes true and will find data from database.
e.g. SELECT * FROM data_table WHERE zone_code > 1;
The following SQL statement select data where zone code is grater than or bigger than 1 from "data_table" table.
≥ Greater than or Equal to Operator
Checks if the value of left operand is greater than or equal to the value of right operand, if yes then condition becomes true and will find data from database.
e.g.
SELECT * FROM data_table WHERE zone_code >= 3;
Or
SELECT * FROM data_table WHERE zone_code ≥ 3;

The following SQL statements select data where zone code is grater than/ bigger than or equal to 3 from "data_table" table.
or OR Operator
The OR operator is used to combine multiple conditions in an SQL statement's WHERE clause.
e.g. SELECT * FROM data_table WHERE zone_name = 'Dhaka' OR zone_name = 'Khulna';
The following SQL statement select "Dhaka" zone data and also "Khulna" zone data from "data_table" table.
< Less than Operator
Checks if the value of left operand is less than the value of right operand, if yes then condition becomes true and will find data from database.
e.g. SELECT * FROM data_table WHERE zone_code < 3;
The following SQL statement select data where zone code is less than or smaller than 3 from "data_table" table.
≤ Less than or Equal to Operator
Checks if the value of left operand is less than or equal to the value of right operand, if yes then condition becomes true and will find data from database.
e.g.
SELECT * FROM data_table WHERE zone_code <= 3;
Or
SELECT * FROM data_table WHERE zone_code ≤ 3;

The following SQL statements select data where zone code is less than/ smaller than or equal to 3 from "data_table" table.
not NOT Operator
The NOT operator reverses the meaning of the logical operator with which it is used. e.g. NOT EXISTS, NOT BETWEEN, NOT IN etc. This is negate operator.
e.g. SELECT * FROM data_table WHERE zone_name NOT IN ('Dhaka', 'Khulna');
The following SQL statement select all data except "Dhaka" and "Khulna" zone from "data_table" table.
( Open Parenthesis
Open parenthesis is used to specify grouping of the start clause, not priority. You can not use only open parenthesis "(" otherwise you will get error.
e.g. SELECT * FROM data_table WHERE zone_name IN ('Dhaka', 'Khulna');
The following SQL statement select "Dhaka" and "Khulna" zone data from "data_table" table.
) Close Parenthesis
Close parenthesis is used to specify grouping of the end clause, not priority. You can not use only open parenthesis ")" otherwise you will get error.
e.g. SELECT * FROM data_table WHERE zone_name IN ('Dhaka', 'Khulna');
The following SQL statement select "Dhaka" and "Khulna" zone data from "data_table" table.
no value NO Value
The no value is used to compare a value with a NULL value.
e.g. SELECT * FROM data_table WHERE zone_name IS NULL;
The following SQL statement select data which zone name is not specified or is null from "data_table" table.
with value WITH Value
The with value is used to compare a value with a NOT NULL value.
e.g. SELECT * FROM data_table WHERE zone_name IS NOT NULL;
The following SQL statement select data which zone name is not blank or has value or is not null from "data_table" table.