write sql query vertical to horiozontal following table
id name
1 100
2 dinesh
3 india
1 101
2 suresh
3 india
1 103
2 prakesh
3 usa
i want output like
id name country
100 dinesh india
101 suresh india
103 prakesh usa
No Answer is Posted For this Question
Be the First to Post Answer
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks
What are teh different tasks that can be created in workflow manager?
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
What all are steps in up gradation of Informatica server?
To achieve the session partition what r the necessary tasks u have to do?
What are roles and groups and benefits of using them?
Different qualification between a related rotate toward the sky and isolates look upward?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
How to compare Source and Target table, without using dynamic lookup?
How will u find weather dimension table is big in size of a fact table?
when we dont use aggregator in mapping ?