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
- 5910 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi,
sel no,name from table group by no,name order by no,name;
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What is the difference between fastload and multiload? Which one is faster?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Why managing the data is important?
How many tables can you join in v2r5?
What are the different softwares used with their functions in teradata?
What is partitioned primary index (ppi)?
What are the available primary index types in teradata.
Define views in teradata with general syntax.
Explain the teradata primary index mechanics in detail with a diagram.
What is the purpose of indexes?
How you will check the version of teradata?
Write a program to show the parser component used in teradata?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Explain teradata utilities?
What do high confidence, low confidence and no confidence mean in explain plan?
