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
What is multi insert?
What are the frequently used data types in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How many tables can you join in v2r5?
What are the various indexes in teradata?
Different phases of multiload?
List the logical and conditional operators that are used with teradata along with their meanings?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is the difference between teradata and basic rdbms?
What exactly do you know about catching in teradata?
In Teradata, what is the significance of UPSERT command?
What are the different softwares used with their functions in teradata?
Difference between inner join and outer join?
What is the use of teradata system software?