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
8636 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

What is aggregate cache in aggregator transformation?

1067

What the difference is between a database, a data warehouse and a data mart?

1082

What are the types of schemas we have in data warehouse.

899

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1849

What is the Process to creating lookup transformation in informatica

984

How many ways are there to do 'remove duplicate records in informatica'?

956

What is sq transformation?

1082

What is option by which we can run all the sessions in a batch simultaneously?

1082

What are the static cache and dynamic cache in informatica?

1140

What is the commit type if you have a transaction control transformation in the mapping?

973

Mention few power centre client applications with their basic purpose?

893

Separate from an archive server and a powerhouse?

908

What is a predefined event?

1037

Which are the different editions of informatica powercenter that are available?

971

What is different between the data warehouse and data mart?

1003