Interested to Buy Any Domain ? << Click Here >> for more details...
what is the query for retrieve the unique values(not display
the duplicates values) from single table?
- 6 Answers
- 10061 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / mohith.dmdw
select distinct <column_name> from <table_name>;
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you mean by ttu in teradata?
Explain and compare pros and cons of snow flake schemas?
Explain the most common data types used in teradata?
Explain the term 'row' related to relational database management system?
What is difference between user and database in teradata?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
Find 2 highest sal from each dept who have completed 5 year in org
List out all forms of LOCKS that are available in Teradata.
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
can we join volatile table with general table an global temporary table with general table ?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
What is the difference between fastload and multiload? Which one is faster?
Teradata 
