Author |
Message |
Ravanabrahma
Bewarse Legend Username: Ravanabrahma
Post Number: 12887 Registered: 06-2004 Posted From: 169.143.0.103
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, March 11, 2010 - 6:03 pm: |
|
Onlymovies:Maryland baa.. what abt u
Oh..nenu denver |
Onlymovies
Celebrity Bewarse Username: Onlymovies
Post Number: 9063 Registered: 01-2009 Posted From: 69.250.72.56
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, March 11, 2010 - 5:39 pm: |
|
Ravanabrahma:ippdudu US lo unnava? ee state lo unnav
Maryland baa.. what abt u Sachin is the highest individual scorer in ODI.
|
Ravanabrahma
Bewarse Legend Username: Ravanabrahma
Post Number: 12886 Registered: 06-2004 Posted From: 169.143.0.103
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, March 11, 2010 - 5:36 pm: |
|
ippdudu US lo unnava? ee state lo unnav |
Ravanabrahma
Bewarse Legend Username: Ravanabrahma
Post Number: 12885 Registered: 06-2004 Posted From: 169.143.0.103
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, March 11, 2010 - 5:35 pm: |
|
ya avunu mama..thanks |
Onlymovies
Celebrity Bewarse Username: Onlymovies
Post Number: 9062 Registered: 01-2009 Posted From: 69.250.72.56
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, March 11, 2010 - 5:34 pm: |
|
So you got the answer... Sachin is the highest individual scorer in ODI.
|
Ravanabrahma
Bewarse Legend Username: Ravanabrahma
Post Number: 12884 Registered: 06-2004 Posted From: 169.143.0.103
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, March 11, 2010 - 5:28 pm: |
|
hmm..ippude similar ga raasa mama..work ayyindi test chesthe.. select hou.organization_id,hou.business_group_id from hr_organization_information hoi ,hr_organization_units hou ,xxhr_i188_employee_stg es where hoi.org_information_context = 'Company Cost Center' and hou.organization_id = hoi.organization_id and nvl(hou.date_to,sysdate) >= sysdate and es.global_emp_id = '6878' AND org_information3 = trim(es.financial_entity_r12) --company and org_information5 = trim(es.cost_center_r12) --COST CENTER and hoi.object_version_number = (select max(hoi.object_version_number) from hr_organization_information hoi ,hr_organization_units hou ,xxhr_i188_employee_stg es where hoi.org_information_context = 'Company Cost Center' and hou.organization_id = hoi.organization_id and nvl(hou.date_to,sysdate) >= sysdate and es.global_emp_id = '6878' AND org_information3 = trim(es.financial_entity_r12) --company and org_information5 = trim(es.cost_center_r12) --COST CENTER ) |
Onlymovies
Celebrity Bewarse Username: Onlymovies
Post Number: 9061 Registered: 01-2009 Posted From: 69.250.72.56
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, March 11, 2010 - 5:25 pm: |
|
select * from table where object_version_number = (selct max(object_version_number) from table) Sachin is the highest individual scorer in ODI.
|
Ravanabrahma
Bewarse Legend Username: Ravanabrahma
Post Number: 12883 Registered: 06-2004 Posted From: 169.143.0.103
Rating: N/A Votes: 0 (Vote!) | Posted on Thursday, March 11, 2010 - 5:20 pm: |
|
oka table lo data ila undi... Org_id business_id object_version_number 1 0 3 2 0 1 ippudu nenu select org_id, business_id.. it should return only the row that is having the maximum value for object_version_number version_number exact ga entha untadi anedi theledu manaki. ela raayali query |