General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Sergey,
I think I understand. So are you saying that SELECT DISTINCT only eliminates rows for which all columns are the same?
I thought that the statement:
SELECT DISTINCT ColumnA ColumnB
would return only 1 row for each unique value of ColumnA.
Are you saying it would return 1 row for each unqiue value of ColumnA and ColumnB?
Thanks, Chaim
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only