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
What is meant by a Least Cost Plan?
How many tables can you join in v2r5?
What is the difference between global temporary tables and volatile temporary tables?
Explain the term 'columns' related to relational database management system?
What is database exceptions in teradata?
What are the various etl tools in the market?
What is the function of parser component in teradata?
what is object level locking ? where do appear this type of locking ?
Difference between inner join and outer join?
What is dimensional modeling?
What is the syntax for case when statement?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
In the Primary Index, what is the score of AMPs that are actively involved?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
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?