what is the query for retrieve the unique values(not display
the duplicates values) from single table?
- 6 Answers
- 9122 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sarma
Select distinct * from table name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain the term 'foreign key' related to relational database management system?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the different functions included in the server software?
What are the design features involved in teradata?
What are some commonly used bteq scripts?
What is the difference between fastload and multiload?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
In Teradata, how do we Generate Sequence?
Comment whether bottleneck is an error or not.
What are the joins in teradata and how many types of joins are there in teradata?
Difference between stored procedure and macro?
Name the five phases that come under MultiLoad Utility.
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the various indexes in teradata? How to use them?
