w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
No SELECT DISTINCT exists but I get: The text data type cannot be selected as DISTINCT because it is not comparable

The UNION clause causes a DISTINCT.

Blog post describing your exact problem: SQL unions and the text data type

© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.