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

Answer Posted / sarma

Select distinct * from table name

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by a Channel Driver?

882


What exactly do you know about catching in teradata?

824


How can you track login parameters of users in teradata?

861


Difference between multiload and tpump?

860


What is real time and near real time data warehousing?

896


In BTEQ, how are the session-mode parameters being set?

925


What is database exceptions in teradata?

743


What is teradata?

861


Difference between star and snowflake schemas?

834


Name the five phases that come under MultiLoad Utility.

785


What is meant by a Highest Cost Plan?

836


If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1971


In Teradata, what is the significance of UPSERT command?

833


What are normalization, first normal form, second normal form and third normal form?

848


What is the command in bteq to check for session settings ?

884