How to query data in DB2 that is not empty?

In DB2, you can use the `IS NOT NULL` condition to query data where a field is not empty. Here is an example query:

SELECT * FROM 表名 WHERE 列名 IS NOT NULL;

Replace ‘table name’ and ‘column name’ with the table name and column name you want to query.

For example, if you want to retrieve data from a table named ’employees’ where the ‘salary’ column is not empty, you can use the following query:

SELECT * FROM employees WHERE salary IS NOT NULL;

This will retrieve data from the `employees` table where the `salary` column is not empty.

Make sure to use the correct table and column names in your queries, and adjust them accordingly based on your actual needs.