| 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 |
Archives-2010