How to check if all values of column are same in oracle?
How to check if all values of column are same in oracle?
1 answer
by
haylee.mertz ,
6 months ago
@darrion.kuhn
You can check if all values in a column are the same in Oracle by using the following SQL query:
1 2 |
SELECT COUNT(DISTINCT column_name) as unique_values FROM table_name |
This query will return the number of unique values in the specified column. If the result is 1, it means that all values in the column are the same.
Related Threads:
How to select values from xml type column in oracle 10g?
How to get unique values from multiple-column values in mysql?
How to fill empty column from another table in oracle?
How to take multiple values from one column in laravel?
How to check null values in mysql?
How to add values in single column of multiple rows in postgresql