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
- 5934 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
Explain the advantages of partitioned primary index in a query?
What are the various indexes in teradata? How to use them? Why are they preferred?
if collect stats but it show low confidence why?
Explain the term 'tables' related to relational database management system?
What are some primary characteristics of teradata?
What are the updated features of teradata?
What are the joins in teradata?
Can we collect statistics on multiple columns?
How does hashing happens in teradata?
What is teradata? What are some primary characteristics of teradata?
What are the steps involved after the disk manager passes the request?
What are the different table types that are supported by teradata?
What are the multiload utility limitations?
How do you do backup and recovery in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
