what is the query for retrieve the unique values(not display the duplicates va

Categories >> Software >> Data Warehouse >> Teradata
Suggest New Category

what is the query for retrieve the unique values(not display
the duplicates values) from single table?

Question Posted / ramesh

6 Answers
9968 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the query for retrieve the unique values(not display the duplicates values) from single ta..

Answer / suneel

Select distinct from tablename

Is This Answer Correct ?

7 Yes

1 No

what is the query for retrieve the unique values(not display the duplicates values) from single ta..

Answer / narsimha

select distinct columnsname from table

Is This Answer Correct ?

2 Yes

0 No

what is the query for retrieve the unique values(not display the duplicates values) from single ta..

Answer / nasimha

above answer is correct

Is This Answer Correct ?

2 Yes

1 No

what is the query for retrieve the unique values(not display the duplicates values) from single ta..

Answer / tdguy

If its for few columns and small table, use distinct or
group by to fetch only unique values. But for more no of
columns and more no of records in GB, use partition by to
fetch only unique values.

Is This Answer Correct ?

1 Yes

0 No

what is the query for retrieve the unique values(not display the duplicates values) from single ta..

Answer / mohith.dmdw

select distinct <column_name> from <table_name>;

Is This Answer Correct ?

0 Yes

0 No

what is the query for retrieve the unique values(not display the duplicates values) from single ta..

Answer / sarma

Select distinct * from table name

Is This Answer Correct ?

0 Yes

0 No

Post New Answer