order by clause Select * from tablename orderby col2 asc;

Hi,
source data is
col1 values are 5,6,7
col2 are 3,2,1
col3 are 8,9,10
and i want to get target as
col1 5,6,7
col2 1,2,3
col3 8,9,10
how to do this one?

Question Posted / benz

6 Answers
8803 Views
I also Faced
E-Mail Answers

Answer Posted / benz

order by clause

Select * from tablename orderby col2 asc;

Is This Answer Correct ?

2 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many input parameters can exist in an unconnected lookup?

1531

What are the differences between oltp and olap?

961

What do you mean by channel change?

1022

Separate from a database, an information bazaar, and an information stockroom?

1073

Can you generate sequence numbers without using the sequence generator transformation?

1102

What is mapping debugger?

991

Describe expression transformation?

1112

explain abt ur project architecture?

2170

what is the size of your data warehousing?

2083

What is the benefit of session partitioning?

1097

Differentiate between joiner and lookup transformation?

1094

What is mapplet in informatica?

1041

What are session parameters ? How do you set them?

1829

How would you copy the content of one repository to another repository?

995

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2099