Author |
Message |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
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. |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
work ayyindhi maama....thanx to Buff,Nayak, Hemu and DE |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
gochi mama, pakkana unna kishore111 naaku Oracle apps cheppina athane mama, aayanni adugu. nayakudu mama iragadesthadu le, kaani aayanni koda kekeyy oo paali. kiki. |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
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 |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
work ayyiddi gada mama aa kinda query yem avuthundi enti |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
primary key ante specialgaa emi ledhu maama...combination of claim,handler,begin_date is a primarykey |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
buff maama...try chesthaa undu |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
tmbuff mama ![](../../clipart/hug1.gif) |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
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 |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
primary key vundaa nee table lo emaina |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
veyy veyy tune chesi d'ga query ni rayyina velthundi data thevataniki ![](../../clipart/hug1.gif) |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
mama primary key emaina vunda... naa query meeda work cheshtunna ippati daka |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
bomma hemuki help chesthavu... ma gosiki seyyava ![](../../clipart/damn.gif) |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
ammani. kastam gane undi mama. ![:-(](../../clipart/sad.gif) |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
idhelaa raayalo seppehe.. |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
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 |
![Top of page](../../icons/mark_top.gif) ![Previous message](../../icons/mark_up.gif) ![Next message](../../icons/mark_down.gif) ![Bottom of page](../../icons/mark_bottom.gif) ![Link to this message](../../icons/tree_m.gif)
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: | ![Edit Post](../../icons/tree_s.gif) ![Delete Post](../../icons/delmsg.gif) ![View Post/Check IP](../../icons/checkip.gif) |
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 ![](../../clipart/blushing.gif) |