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 - 2011 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through September 22, 2011 * SQL Query Help < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13994
Registered: 08-2009
Posted From: 216.105.250.4

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 9:07 am:    Edit Post Delete Post View Post/Check IP
Aggi_pidugu:

Nuvvu adgina question ki correlated subquery avasarama ani sasibabu adagamannadu



Avasaram ledhu aaa? mari how?MOVIEART--bemmi.adi
Super Star Prince Mahesh Rocks !
Top of pagePrevious messageNext messageBottom of page Link to this message

Aggi_pidugu
Bewarse Legend
Username: Aggi_pidugu

Post Number: 30252
Registered: 05-2006
Posted From: 66.193.93.3

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 9:05 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:

And moreover nenu use chestundhi netezza kaabati coorelated sub querys work kaadhu... inka vere method emanna vundhi emo ani thed vesaanu...



Nuvvu adgina question ki correlated subquery avasarama ani sasibabu adagamannadu MOVIEART--bemmi.aggipulla
ITALIAN MAFIASO CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13992
Registered: 08-2009
Posted From: 216.105.250.4

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 8:52 am:    Edit Post Delete Post View Post/Check IP
Aggi_pidugu:

Sasibabu:



Query ela raayali anthe Informatica developer aa ani adugutaar enti Annai's.. Informatica use chesi naaku kavalsina vidhamga output techukunna.. Kaani query ela raayali ani na doubt ikkada.....And moreover nenu use chestundhi netezza kaabati coorelated sub querys work kaadhu... inka vere method emanna vundhi emo ani thed vesaanu...MOVIEART--bemmi.lungi
Super Star Prince Mahesh Rocks !
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Mudiripoyina Bewarse
Username: Sasibabu

Post Number: 4943
Registered: 10-2010
Posted From: 72.181.164.235

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 8:31 am:    Edit Post Delete Post View Post/Check IP
Aggi_pidugu:


MOVIEART--bemmi.lungi2
Jest; oodigam Batch
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Mudiripoyina Bewarse
Username: Sasibabu

Post Number: 4942
Registered: 10-2010
Posted From: 72.181.164.235

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 8:30 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:


idhi oka requirement ...dheeniki nuvvu thed esi adagatamMOVIEART--avataram
Jest; oodigam Batch
Top of pagePrevious messageNext messageBottom of page Link to this message

Aggi_pidugu
Bewarse Legend
Username: Aggi_pidugu

Post Number: 30250
Registered: 05-2006
Posted From: 66.193.93.3

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 8:27 am:    Edit Post Delete Post View Post/Check IP
Onlyniru3:

edhi annai.. meeru cheppindhi?



nuvvu informatica developer va MOVIEART--normuy
ITALIAN MAFIASO CLIPART--smoke
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13991
Registered: 08-2009
Posted From: 216.105.250.4

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 7:51 am:    Edit Post Delete Post View Post/Check IP
Codes:

nenu seppindi adee kadha..



edhi annai.. meeru cheppindhi?
Super Star Prince Mahesh Rocks !
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 62619
Registered: 05-2006
Posted From: 212.60.115.186

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:48 am:    Edit Post Delete Post View Post/Check IP
nenu seppindi adee kadha.. CLIPART--angryfire
I have no budget for other people's faith in humanity.
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13990
Registered: 08-2009
Posted From: 216.105.250.4

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:43 am:    Edit Post Delete Post View Post/Check IP
Exists clause Use chesthe work avutundhi anukunta Neteeza lo..
Super Star Prince Mahesh Rocks !
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13989
Registered: 08-2009
Posted From: 216.105.250.4

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:43 am:    Edit Post Delete Post View Post/Check IP
Thanks Kothi annai :-)... Actual ga meeru cheppindhi correct ... Adi oracle lo work avutundhi... Nenu Netezza DB vaadutunna...
Error vachindhi

Error: ERROR: (2) This form of correlated query is not supported - consider rewriting
(State:HY000, Native Code: 2D)
Super Star Prince Mahesh Rocks !
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13988
Registered: 08-2009
Posted From: 216.105.250.4

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:39 am:    Edit Post Delete Post View Post/Check IP
Thank You KC annai :-)
Super Star Prince Mahesh Rocks !
Top of pagePrevious messageNext messageBottom of page Link to this message

Kothi
Mudiripoyina Bewarse
Username: Kothi

Post Number: 2507
Registered: 09-2004
Posted From: 115.112.231.105

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:37 am:    Edit Post Delete Post View Post/Check IP
SELECT * FROM SourceTable A
WHERE eff_ts<>
(SELECT MAX(eff_ts) FROM SourceTable B WHERE A.SALES_CRM_OPPTY_ID= B.SALES_CRM_OPPTY_ID
GROUP BY SALES_CRM_OPPTY_ID)

idi try cheyyi Niru tammi
Top of pagePrevious messageNext messageBottom of page Link to this message

Kingchoudary
Bewarse Legend
Username: Kingchoudary

Post Number: 66476
Registered: 03-2004
Posted From: 62.12.14.24

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:28 am:    Edit Post Delete Post View Post/Check IP
Penkulu naa pakka cubic lo kukoni call lo vunnadu, velli cheppostha Niru thammi yee thread chudamani....
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 62618
Registered: 05-2006
Posted From: 212.60.115.186

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:26 am:    Edit Post Delete Post View Post/Check IP
select eff_ts from x where eff_ts not in (Select max(eff_ts) from x)ยจ

itta try seyyi
I have no budget for other people's faith in humanity.
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13987
Registered: 08-2009
Posted From: 216.105.250.4

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:22 am:    Edit Post Delete Post View Post/Check IP
kudaratam ledhu annai.. manam komcham week SQL lo....:-(
Super Star Prince Mahesh Rocks !
Top of pagePrevious messageNext messageBottom of page Link to this message

Codes
Bewarse Legend
Username: Codes

Post Number: 62617
Registered: 05-2006
Posted From: 212.60.115.186

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:17 am:    Edit Post Delete Post View Post/Check IP
Sub Query rayochu emo kadha "Not In" ani..
I have no budget for other people's faith in humanity.
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 13986
Registered: 08-2009
Posted From: 216.105.250.4

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 21, 2011 - 6:04 am:    Edit Post Delete Post View Post/Check IP
Consider a scenario - Source is like below

SALES_CRM_OPPTY_ID||eff_ts ||exprtn_ts ||curr_ind
0063000000A6ANEAA3||2007-06-06 07:36:45||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2007-09-12 21:54:48||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2007-09-13 21:46:02||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2008-10-02 20:56:33||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2008-10-04 09:11:18||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2009-08-24 22:13:44||9999-12-31 00:00:00||Y

From the above I need to get all the records except last record which has max(eff_ts). So for a particular sales_crm_oppty_id I need to get all the records except the record having max(eff_ts )

So output should be like this
SALES_CRM_OPPTY_ID||eff_ts ||exprtn_ts ||curr_ind
0063000000A6ANEAA3||2007-06-06 07:36:45||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2007-09-12 21:54:48||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2007-09-13 21:46:02||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2008-10-02 20:56:33||9999-12-31 00:00:00||Y
0063000000A6ANEAA3||2008-10-04 09:11:18||9999-12-31 00:00:00||Y

420 uncle, Stewie, Pokiri, Dobbey etc etc annai's help me..
Super Star Prince Mahesh Rocks !

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