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

Answer Posted / narsimha

select distinct columnsname from table

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are tpump utility limitations?

893


How many sessions of MAX is PE capable of handling at a particular time?

840


Differentiate primary key and partition key?

785


What is node? How many nodes and amps used in your previous project?

906


What is a node in teradata?

790


What are the various indexes in teradata? Why are they preferred?

784


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1512


What are default access rights in teradata?

883


What are the different functions performed in development phase?

866


How many codd's rules are satisfied by teradata database?

915


What are some primary characteristics of teradata?

782


What is the use of teradata system software?

810


How do you determine the number of sessions?

846


What are teradata utilities?

866


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

870