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
- 7268 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 |
Explain teradata architecture in detail with a diagram.
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?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are the joins in teradata and how many types of joins are there in teradata?
How does hashing happens in teradata?
why varchar takes 2 extra bytes?
How to load specific no.of records using bteq, or fastload,or multiload
What is teradata?
What are the different functions included in the server software?
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
What is meant by Teradata Gateway?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Teradata 
