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
- 6945 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 |
What is meant by a Highest Cost Plan?
can we load 10 millions of records into target table by using tpump?
Highlight the need for Performance Tuning.
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
Aborted in Phase 1 data Acquistion Incomplete in fastload?
how do you manage the production space. what are the proactive methods you can take ?
Describe primary index in teradata. And what are the available primary index types?
If RDBMS is halted what will you do ?
What is the difference between teradata and oracle?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.
How many types of index are present in teradata?
What are the components provided on node?
Teradata 
