| Author | Message | ||
     Dreamcatcher Side Hero Username: Dreamcatcher Post Number: 2608 Registered: 11-2009 Posted From: 208.86.145.68 Rating: N/A |
Are you not grouping by the FROMCUR? | ||
| Sachin Megastar Username: Sachin Post Number: 27584 Registered: 04-2008 Posted From: 209.249.19.126 Rating: N/A |
separate rows endi adhyakshaaa.... USA ki okate row vasthadi...with 4 columns share ki gross ki thedaa theliyakapothenemi..daatar maaya box office disco lo iragadeesthaaadu... ki ki ki ... | ||
| Uppu Side Hero Username: Uppu Post Number: 4540 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
Database version 10g, pivot is not working “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Uppu Side Hero Username: Uppu Post Number: 4538 Registered: 11-2007 Posted From: 76.103.128.193 Rating: N/A |
this works when you have group , I do not have that “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Uppu Side Hero Username: Uppu Post Number: 4537 Registered: 11-2007 Posted From: 76.103.128.193 Rating: N/A |
this bring three separate rows, I want them in one row “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Dreamcatcher Side Hero Username: Dreamcatcher Post Number: 2605 Registered: 11-2009 Posted From: 96.255.49.11 Rating: N/A |
Like the example shown here... http://www.oracle-developer.net/display.php?id=515 | ||
| Dreamcatcher Side Hero Username: Dreamcatcher Post Number: 2604 Registered: 11-2009 Posted From: 96.255.49.11 Rating: N/A |
If you are on 11g, you can use LISTAGG function. | ||
| Sachin Megastar Username: Sachin Post Number: 27568 Registered: 04-2008 Posted From: 68.44.58.32 Rating: N/A |
nee enks uppu...etayipoyyyaaav share ki gross ki thedaa theliyakapothenemi..daatar maaya box office disco lo iragadeesthaaadu... ki ki ki ... | ||
| Sachin Megastar Username: Sachin Post Number: 27567 Registered: 04-2008 Posted From: 68.44.58.32 Rating: N/A |
SELECT fromcur, MAX( CASE WHEN TOCUR = 'JPY' THEN rate END) japan_rate, MAX( CASE WHEN TOCUR = 'CHN' THEN rate END) china_rate, MAX( CASE WHEN TOCUR = 'GBP' THEN rate END) gbp_rate FROM rates where fromcur = 'USD' and TOCUR in ('JPY','CHN', 'GBP') GRUOP BY fromcur share ki gross ki thedaa theliyakapothenemi..daatar maaya box office disco lo iragadeesthaaadu... ki ki ki ... | ||
| Sachin Megastar Username: Sachin Post Number: 27566 Registered: 04-2008 Posted From: 68.44.58.32 Rating: N/A |
SELECT fromcur, MAX( CASE WHEN TOCUR = 'JPY' THEN rate END) japan_rate MAX( CASE WHEN TOCUR = 'CHN' THEN rate END) china_rate MAX( CASE WHEN TOCUR = 'GBP' THEN rate END) gbp_rate FROM rates where fromcur = 'USD' and TOCUR in ('JPY','CHN', 'GBP') GRUOP BY fromcur share ki gross ki thedaa theliyakapothenemi..daatar maaya box office disco lo iragadeesthaaadu... ki ki ki ... | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 6996 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
try this: select fromcur, wm_concat(RATE) from RATES where TOCUR in (..) and fromcur='USD' group by fromcur All Class Notes -> https://twitter.com/#!/EKSWAcademy all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 2416 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
use pivot ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Ustad Side Hero Username: Ustad Post Number: 8417 Registered: 07-2008 Posted From: 65.161.188.11 Rating: N/A |
http://www.dba-oracle.com/t_sql_output_one_line.htm Fan of Fab 5: Sachin, Rahul, Saurav, Laxman and Kumble. | ||
| Maverick Legend Username: Maverick Post Number: 35399 Registered: 01-2008 Posted From: 192.146.101.24 Rating: N/A |
if u r ok with non sql methids, dump table to a file and use awk to transpose Who is this DB member? | ||
| Maverick Legend Username: Maverick Post Number: 35397 Registered: 01-2008 Posted From: 192.146.101.24 Rating: N/A |
chala methods untai..check this by burleson htata http://www.dba-oracle.com/t_converting_rows_columns.htm Who is this DB member? | ||
| Gandhiguevara Megastar Username: Gandhiguevara Post Number: 25533 Registered: 10-2009 Posted From: 66.151.13.188 Rating: N/A |
Tom gaadni adigava? http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUES TION_ID:766825833740 | ||
| Uppu Side Hero Username: Uppu Post Number: 4536 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
I think it works with group by “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Uppu Side Hero Username: Uppu Post Number: 4535 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
select * from rates where fromcur = 'USD' and TOCUR in ('JPY','CHN', 'GBP') Result FROMCUR TOCUR RATE USD JPY .23 USD chN .12 USD gbp 1.2 But i want them all three in one row. .23 .12 1.2 “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Maverick Legend Username: Maverick Post Number: 35396 Registered: 01-2008 Posted From: 192.146.101.24 Rating: N/A |
pivot operator edo undi ga..did u try? Who is this DB member? | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 6989 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
post the table ddl easier to help All Class Notes -> https://twitter.com/#!/EKSWAcademy all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Sachin Megastar Username: Sachin Post Number: 27565 Registered: 04-2008 Posted From: 68.44.58.32 Rating: N/A |
bhayyaaa...sample data and final output pettu.... nuvvu chepppe daannibatti pivoting cheyyali ani ardham ayindi naaaku share ki gross ki thedaa theliyakapothenemi..daatar maaya box office disco lo iragadeesthaaadu... ki ki ki ... | ||
| Kuyyo_morro Side Hero Username: Kuyyo_morro Post Number: 6352 Registered: 02-2011 Posted From: 63.76.147.112 Rating: N/A |
http://msdn.microsoft.com/en-us/library/ms177410.aspx | ||
| Uppu Side Hero Username: Uppu Post Number: 4534 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
from country fixed, to country changes “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Uppu Side Hero Username: Uppu Post Number: 4533 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
I want .45 .56 1 row to column “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Uppu Side Hero Username: Uppu Post Number: 4532 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
no country table, I know the from and two currency I want. regular query brings them as 3 rows. but I want them in single coloumn “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Maverick Legend Username: Maverick Post Number: 35395 Registered: 01-2008 Posted From: 192.146.101.24 Rating: N/A |
FROM TO XCHRATE USD INR .45 CAN USD .56 JPY USD 1 ippudu em kavali? Who is this DB member? | ||
| Uppu Side Hero Username: Uppu Post Number: 4531 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
Currency rate table lo data from cur to cur rate untayi, i need 3 different coutry rates in one query “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Cyberabadsinnodu Side Hero Username: Cyberabadsinnodu Post Number: 2414 Registered: 02-2010 Posted From: 67.163.149.59 Rating: N/A |
SELECT countries.name , currency_countries.country_code , currencies.name , currency_countries.currency_code , currencies.current_rate FROM currency_country INNER JOIN currencys ON currency_country.currency_code = currencys.code INNER JOIN countries ON currency_country.country_code = countries.code ఎంత చికాగో యునివర్సిటీ లో చదువుకున్నా చిలక్కొట్టుడికి సరైన ఇంగ్లీషు పదం దొరుకుతుందా..!! | ||
| Ustad Side Hero Username: Ustad Post Number: 8415 Registered: 07-2008 Posted From: 76.173.42.79 Rating: N/A |
Can you describe the table/tables in question and also sample output you are looking for? Fan of Fab 5: Sachin, Rahul, Saurav, Laxman and Kumble. | ||
| Uppu Side Hero Username: Uppu Post Number: 4530 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
I think pivot work with group by only “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Sachin Megastar Username: Sachin Post Number: 27560 Registered: 04-2008 Posted From: 68.44.58.32 Rating: N/A |
question ardham kaaale share ki gross ki thedaa theliyakapothenemi..daatar maaya box office disco lo iragadeesthaaadu... ki ki ki ... | ||
| Kuyyo_morro Side Hero Username: Kuyyo_morro Post Number: 6349 Registered: 02-2011 Posted From: 63.76.147.112 Rating: N/A |
Subquery raayali. | ||
| Uppu Side Hero Username: Uppu Post Number: 4529 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
konchem detail ga cheppandi, need to multiply USD-JPY with usD-gbp in same query “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” | ||
| Entikaburlu Side Hero Username: Entikaburlu Post Number: 6984 Registered: 07-2011 Posted From: 67.247.83.224 Rating: N/A |
pivoting?? hint: wm_concat All Class Notes -> https://twitter.com/#!/EKSWAcademy all opinions expressed are mine and only mine. not to be attributed to the other IP address sharers, my employer, or any other human, animal, robot or alien. | ||
| Uppu Side Hero Username: Uppu Post Number: 4526 Registered: 11-2007 Posted From: 206.16.32.136 Rating: N/A |
three countries Currency rates single query extract cheyyali. other than using same table thrice in query emanna options unnaya “Generations to come will scarce believe that such a one as this walked the earth in flesh and blood.” |
