Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets
Bewarse Talk Discussion Board * Archives-2010 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through March 12, 2010 * SQL Question < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this 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:    Edit Post Delete Post View Post/Check IP


Onlymovies:

Maryland baa..
what abt u




Oh..nenu denver
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post View Post/Check IP


Ravanabrahma:

ippdudu US lo unnava? ee state lo unnav


Maryland baa..
what abt u
Sachin is the highest individual scorer in ODI.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post View Post/Check IP

ippdudu US lo unnava? ee state lo unnav
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post View Post/Check IP

ya avunu mama..thanks :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post View Post/Check IP

So you got the answer...
Sachin is the highest individual scorer in ODI.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post View Post/Check IP

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
)
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post View Post/Check IP

select * from table where object_version_number = (selct max(object_version_number) from table)
Sachin is the highest individual scorer in ODI.
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post View Post/Check IP

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

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration