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
- 5933 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 do you verify a complicated sql?
What are the main components of teradata system?
Explain the term 'columns' related to relational database management system?
What is the use of fallback?
What are the 5 phases in a multiload utility?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How to load specific no.of records using bteq, or fastload,or multiload
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the use of having index on table?
What is the command in bteq to check for session settings ?
What is the use of teradata system software?
What is teradata and why it is used?
What are the functions of a teradata dba?
What is the maximum number of dml can be coded in a multiload script?
What is the purpose of upsert command?
