How to search a numeric column in teradata?

by herminia_bruen , in category: MySQL , 5 months ago

How to search a numeric column in teradata?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by addison , 5 months ago

@herminia_bruen 

To search a numeric column in Teradata, you can use the following SQL query:


SELECT * FROM table_name WHERE numeric_column = value;


Replace "table_name" with the name of the table you want to query and "numeric_column" with the name of the numeric column you want to search. Replace "value" with the specific numeric value you are looking for in the column.


For example, if you wanted to search a numeric column called "salary" in a table called "employees" for the value 50000, you would use the following query:


SELECT * FROM employees WHERE salary = 50000;


This query will return all rows from the "employees" table where the "salary" column has a value of 50000.

Related Threads:

How to search teradata column descriptions?
How to copy column names from teradata?
How to update column with row_number() in teradata?
How to update a column with a null value in teradata?
How to get column count from a table in teradata?
How to handle nulls in date column in teradata?