| Author |
Message |
    
Bommarillu
Pilla Bewarse
Username: Bommarillu
Post Number: 280
Registered: 07-2005
Posted From: 12.41.255.10
| | Posted on Tuesday, May 02, 2006 - 4:04 pm: |    |
Naku chala work echaru so db ki velle time kuda ledu. sorry gochi garu. If you have a sql problem please do not hesitate to ask me. I like to try out different scenarios just to see if i could get the end result. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19777
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, May 02, 2006 - 2:37 pm: | |
 work ayyindhi maama....thanx to Buff,Nayak, Hemu and DE |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15308
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Tuesday, May 02, 2006 - 2:32 pm: | |
gochi mama, pakkana unna kishore111 naaku Oracle apps cheppina athane mama, aayanni adugu. nayakudu mama iragadesthadu le, kaani aayanni koda kekeyy oo paali. kiki. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19775
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, May 02, 2006 - 2:28 pm: | |
here you. Assuming your table as temp (a1,a2,a3,a4), user this sql
select * from (select min(a3) a3,a1 from temp group by a1) x, temp b
where x.a1 =b.a1
and x.a3 =b.a3
maama...adhi pani chesthundi kaani...naakinko condition undi..like another column undi like job_code...
Claim,Handler,Begin_date,End_date,JOb_code
A124 , John , 04/06/06 ,04/09/06,JAR
A124 , Rob , 04/09/06, 04/12/06 ,RAM
A124, Steve, 04/12/06, 04/18/06 ,UYT
A124 , John, 04/18/06 , 04/20/06 ,JAR
A124 , Ren , 04/20/06, null,RAM
so ilaa unnappudu naaku RAM job code unnavaallo least begin date unna Handler,claim kaavali..
paidhi deeniki pani cheyyatledhu |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3385
Registered: 05-2005
Posted From: 136.182.2.222
| | Posted on Tuesday, May 02, 2006 - 2:26 pm: | |
work ayyiddi gada mama aa kinda query yem avuthundi enti |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19771
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, May 02, 2006 - 12:38 pm: | |
primary key ante specialgaa emi ledhu maama...combination of claim,handler,begin_date is a primarykey |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19770
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, May 02, 2006 - 12:33 pm: | |
buff maama...try chesthaa undu |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3378
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, May 02, 2006 - 12:24 pm: | |
tmbuff mama  |
Tmbuff
Pilla Bewarse
Username: Tmbuff
Post Number: 145
Registered: 04-2004
Posted From: 24.128.247.72
| | Posted on Tuesday, May 02, 2006 - 12:21 pm: | |
Hi Gochi --
here you. Assuming your table as temp (a1,a2,a3,a4), user this sql
select * from (select min(a3) a3,a1 from temp group by a1) x, temp b
where x.a1 =b.a1
and x.a3 =b.a3 |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3377
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, May 02, 2006 - 12:20 pm: | |
primary key vundaa nee table lo emaina |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3376
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, May 02, 2006 - 12:19 pm: | |
veyy veyy tune chesi d'ga query ni rayyina velthundi data thevataniki |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3375
Registered: 05-2005
Posted From: 136.182.2.221
| | Posted on Tuesday, May 02, 2006 - 12:18 pm: | |
mama primary key emaina vunda... naa query meeda work cheshtunna ippati daka |
Donga_evaru
Bewarse ke Bewarse!
Username: Donga_evaru
Post Number: 15970
Registered: 08-2004
Posted From: 134.130.245.153
| | Posted on Tuesday, May 02, 2006 - 12:15 pm: | |
bomma hemuki help chesthavu... ma gosiki seyyava  |
Hemanth
Bewarse ke Bewarse!
Username: Hemanth
Post Number: 15298
Registered: 03-2004
Posted From: 65.196.167.82
| | Posted on Tuesday, May 02, 2006 - 12:11 pm: | |
ammani.
kastam gane undi mama.  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19766
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, May 02, 2006 - 11:52 am: | |
 idhelaa raayalo seppehe.. |
Nayakudu
Vooriki Bewarse
Username: Nayakudu
Post Number: 3374
Registered: 05-2005
Posted From: 129.188.33.222
| | Posted on Tuesday, May 02, 2006 - 11:48 am: | |
naa query ninna run ayyindi.. ee roju rows return cheyyataniki chala thantalu paduthundi... oka condition add chesthene ila ayyindi...
explain plan chusa oke execution path same cost vundi kani rows return cheyyataniki chala time paduthundi.. chasthunna |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 19765
Registered: 07-2004
Posted From: 162.136.192.1
| | Posted on Tuesday, May 02, 2006 - 11:45 am: | |
oka chinna query raayaneeki thannukuntunna 2 hrsgaa...Bangaram tensiono emo..
oka table lo 4 columns unnayi
Claim,Handler,Begin_date,End_date
A124 , John , 04/06/06 ,04/09/06
A124 , Rob , 04/09/06, 04/12/06
A124, Steve, 04/12/06, 04/18/06
A124 , John, 04/18/06 , null
ilaa untundhi data...who ever is presently handling the claim their end_date will be null...
ippudu naaku kaavalsindhi, I want each claim,the handler who ever is assigned first and his begin_date (who is having the min(begin_date)
idhi elaa cheyyalo evalanna help sesi punyam kattukondi  |
