one table have
input
no name
10 rao
20 siva
30 srinu
10 rao
i want to ouput like this way
no name
20 siva
30 srinu
10 rao
how it posible in only sql server query?not oracle?
Answers were Sorted based on User's Feedback
Answer / babu
Hi,
sel no,name from table group by no,name order by no,name;
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / ankal
This problm solve only using Distinct or Group by
syntax:
1:sel distinct no,name from tablename;
2:sel no,name from tablename group by no,name;
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / tdguy
use distinct or group by to avoid duplicates in teradata.
Is This Answer Correct ? | 1 Yes | 0 No |
What are different table types used in teradata?
plz explain parlla distribution and subtable concept in teradata
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
How you will check the version of teradata?
How many macros we can create inside a macro
What is the use of having index's on table?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
What is upsert statement in teradata?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
Which is more efficient group by or distinct to find duplicates?
What are the various indexes in teradata? Why are they preferred?
What is the difference between fastload and multiload?