what is the query for retrieve the unique values(not display
the duplicates values) from single table?
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 |
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
What is partitioned primary index (ppi)?
What are the joins in teradata and how many types of joins are there in teradata?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
Which is more efficient group by or distinct to find duplicates?
what is differences between Fastload and Multiload as per DBA aspect ?
Why is the case expression used in teradata?
How does hashing happens in teradata?
Different phases of multiload?
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
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
how can we analyze the locks ?