Get Telemetry Data without "null"

[abdullah123456789]

Hello,

I created an SQL Query in Geo SCADA Expert 2021 as in the below.

When I exported the Telemetry Signal List after creating the query, I saw "null" data. This "null" data should not be displayed

I did some filtering in this screen in the below but I couldn't be successful. Which filter i must choose?

[AndrewScott · Accepted solution]

To filter the resultset of an SQL query based on a column not being NULL use the <column> IS NOT NULL syntax:

https://www.w3schools.com/sql/sql_null_values.asp 

The current value of a point is NULL when it has never been updated and the OPC quality will be 'waiting for initial data'.

[BGedco2022]

"select x,y, z

from tableName

where x is not null"

To filter a results without null values 

OR another filter

where x >= 0

[AndrewScott]

The correct syntax to exclude NULL values is:

SELECT X, Y, Z FROM TABLE WHERE X IS NOT NULL

The following syntax will not work as the SQL standard specifies that the comparison operators (=, <>, >= etc.) cannot be used to test for NULL (see https://www.w3schools.com/sql/sql_null_values.asp😞

SELECT X, Y, Z FROM TABLE WHERE X <> NULL

[abdullah123456789]

Thanks for help. It worked.

[khanzain]

To refine the resultset of an SQL query by excluding rows where a specific column is NULL, employ the syntax <column> IS NOT NULL. For detailed information, refer to the following link:
https://www.w3schools.com/sql/sql_null_values.asp.

https://iqratechnology.com/academy/sql-training/sql-null/

In the context of point values, a NULL signifies that the point has not been updated, and the associated OPC quality is designated as 'waiting for initial data.