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
- 6943 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain and compare pros and cons of snow flake schemas?
Difference between multiload and tpump?
What is the use of fallback?
What are the string manipulation operators and functions associated with teradata?
What is the use of having index on table?
If RDBMS is halted what will you do ?
In general, how do you optimze any sql in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is the multi-insert?
How many sessions of MAX is PE capable of handling at a particular time?
Explain Teradata performance tuning and optimization?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are types of partition primary index (ppi) in teradata?
How can bottlenecks be identified?
What are the scenarios in which full table scans occurs?
