Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 7142 Views
- IBM, I also Faced
- E-Mail Answers
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 |
how to load or extract the error table data ?
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
how teradata fetches a row from primary index table?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Explain PDE.
why varchar takes 2 extra bytes?
What are the functions involved in shared information architecture?
What is differnce between Error code and Error Level in Bteq
What is the difference between correlated sub queries and inner queries?
Highlight the points of differences between the database and user in Teradata.
Explain the term 'database' related to relational database management system?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
Teradata 
