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 |
Explain the term 'foreign key' related to relational database management system?
Did you write stored procedures in teradata?
what is meant by Hot amp?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is upsert statement in teradata?
can we join volatile table with general table an global temporary table with general table ?
What's the difference between timestamp (0) and timestamp (6)?
How to cast date "2015-03-03-012204-000000" to timestamp
How do you Generate Sequence in Teradata?
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
What is meant by a Channel Driver?