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
- 5909 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
How to eliminate product joins in a teradata sql query?
How does hashing happens in teradata?
What are the frequently used data types in teradata?
What are the primary characteristics of the Teradata.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Describe the set operators in teradata.
What is node? How many nodes and amps used in your previous project?
List out all forms of LOCKS that are available in Teradata.
What do you mean by ttu in teradata?
How would you load a very large file in teradata in general?
What is teradata?
What is the purpose of joins in teradata and what are the available join types?
What are the various reporting tools in the market?
What is the difference between teradata and basic rdbms?
What are the functions involved in shared information architecture?
