How to get data without duplicates for two columns from the same table

Question

select DISTINCT column1, (select DISTINCT column2 from table1 ) from table1

I want both column1 and column2 value without duplicate

Can you please add some info clearly with result output. select distinct column1,column2 from table would do — Ven, Jun 22 '17 at 10:51
.i was working in month selection table with column1 contain n number of month name in english and column2 contain n number of month name in local language. i want month in english & local language in 12 rows with two column without duplication — Ratheesh krishna, Jun 22 '17 at 11:15

score 1 · Accepted Answer · answered Jun 22 '17 at 10:58

1

SELECT DISTINCT value FROM Table1 CROSS APPLY ( VALUES ('COLUMN1', Column1), ('COLUMN2', Column2) ) c(col, value) WHERE value IS NOT NULL

answered Jun 22 '17 at 10:58

Alexandru-Dan Pop

Its working can u pls help as how to order it by month wise – Ratheesh krishna Jun 22 '17 at 11:08
Sorry but I don't understand exactly what you want. Please be more specific, maybe post a new questions explaining exactly what you want to do and what you tried until now. – Alexandru-Dan Pop Jun 22 '17 at 11:15

score 0 · Answer 2 · edited Jun 22 '17 at 10:52

0

select distinct column1
               ,column2
from table1

edited Jun 22 '17 at 10:52

iamdave

answered Jun 22 '17 at 10:50

Pablo notPicasso

i don't know if he is asking for that ,for example [a,b][a,c] ar not duplicate in row but in column according with what he is asking . – Frank Jun 22 '17 at 10:53
i tried it but not Working...i was working in month selection table with column1 contain n number of month name in english and column2 contain n number of month name in local language. i want month in english & local language in 12 rows with two column without duplication – Ratheesh krishna Jun 22 '17 at 11:02

score 0 · Answer 3 · answered Jun 22 '17 at 10:53

0

If you have only few duplicates, then

SELECT DISTINCT Column1, Column2 from table1

If you have many duplicates, then

SELECT Column1, Column2 from table1 GROUP BY Column1, Column2

answered Jun 22 '17 at 10:53

Arun Nadaraj

1

Why do you think there is a difference between these two statements? They are syntactically identical and doing the same thing inside the SQL Engine – iamdave Jun 22 '17 at 10:54

score 0 · Answer 4 · answered Jun 22 '17 at 11:01

0

select distinct column1,column2 from table1;

answered Jun 22 '17 at 11:01

Ritwik Sahay

4 Answers4