Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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?

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 can we update a record in the target table without using update strategy?

1149


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2160


What are session parameters ? How do you set them?

1850


How can we store previous session logs?

1081


can u give example for factless fact table

6649


Explain the pipeline partition with real time example?

1144


In how many ways we can create ports?

1123


What is the procedure for creating independent data marts from informatica 7.1?

1066


Differentiate between source qualifier and filter transformation?

1578


What do you mean by enterprise data warehousing?

1065


How can you validate all mappings in the repository simultaneously?

1371


Tell me about Propagate functions in informatica

922


What is the Process to creating lookup transformation in informatica

1045


Differentiate between a repository server and a powerhouse?

1118


What are the components of Informatica? And what is the purpose of each?

1055