Sql Help Kaavaali Chaala Simple Jara Ochhi Chusi Answer Cheppunri

[c3x]

[quote name='charygaru' timestamp='1349375976' post='1302582139']
.



[b]naaku answer ochhinda leda anedi important kadu mama nuvvu cheppina solution nenu adigina question ki saripothada leda annadi naaku telvatam importtant anthe. nuvvu cheppinadi vinnaka naaku em ardham ayyindi ante aa id number lo ekkada 0 unte akkada nuncchi position -1 ki ( imean aa zero mundu ki) osthadi anukunna[/b]
[/quote]
nuvu racha mama [img]http://lh6.ggpht.com/-DUcF-Vl9sRQ/UGD9ApRDU-I/AAAAAAAAHb8/1Pppqj3ONZM/s150/Brahmi-1.gif[/img]

[c3x]

[quote name='charygaru' timestamp='1349376091' post='1302582150']
claps kottanbiki chethulu kaali lev gaani tarvatha kanipinchu
[/quote]
nuvu keka ehes[img]http://lh6.ggpht.com/-DUcF-Vl9sRQ/UGD9ApRDU-I/AAAAAAAAHb8/1Pppqj3ONZM/s150/Brahmi-1.gif[/img]

[padmasri123]

[quote name='charygaru' timestamp='1349375976' post='1302582139']
nenu BA ne mama kaani sql lo select statements use cheyyalsi osthundi konni ids kanukoni vaatilo secondry level numbers ni veru chesi raka rakala scenarios test cheyyali aa process lo primary id raakunda chudataniki last lo 0 unde numbers eliminate cheyyali le anduke ee question.



naaku answer ochhinda leda anedi important kadu mama nuvvu cheppina solution nenu adigina question ki saripothada leda annadi naaku telvatam importtant anthe. nuvvu cheppinadi vinnaka naaku em ardham ayyindi ante aa id number lo ekkada 0 unte akkada nuncchi position -1 ki ( imean aa zero mundu ki) osthadi anukunna
[/quote]

nope ....mee id lo 120340 undanuko
manaki 3rd and 6th position lo 0 undi so kinda query

instr(id,0,-1) gives the position of 0 from last character..gives 6 ---ante -1 anedi last character nunchi start chesi ekkada zero unte aa value return chestadi

[charygaru]

[quote name='padmasri123' timestamp='1349376260' post='1302582165']

nope ....mee id lo 120340 undanuko
manaki 3rd and 6th position lo 0 undi so kinda query

instr(id,0,-1) gives the position of 0 from last character..gives 6 ---ante -1 anedi last character nunchi start chesi ekkada zero unte aa value return chestadi
[/quote]

oh now i get it mama so that same logic is applied to all the columns and every id number with a 0 is returned aa leka omitted aa in the result set, when ur query is used ??

[padmasri123]

[quote name='charygaru' timestamp='1349376371' post='1302582177']
oh now i get it mama so that same logic is applied to all the [color=#ff0000]columns[/color] and every id number with a 0 is returned aa leka omitted aa in the result set, when ur query is used ??
[/quote]

avunu charygaru ...columns kadu rows ki

[kiran1012]

[quote name='charygaru' timestamp='1349375699' post='1302582113']
but mama naaku position of 0 kaadu kaavalansinddhi only last position lo 0 unte aa record eliminate avvali result set nuchi anthe. anduke nee complex query naaku ardham kaale and nenu cheppindi neeku ardham kaale anukunte for being vague
[/quote]

basically instr function syntax : INSTR( source_string, substring , start_position )[list]
[*]Here [b]source_string [/b]is as per ur requirement "[color=#282828][font=helvetica, arial, sans-serif]123456789000[/font][/color]"
[*][b]substring [/b]is is the character string ('0') to be searched for inside of source_string "[color=#282828][font=helvetica, arial, sans-serif]123456789000[/font][/color]"
[*][b]start_position (will be integer value) [/b]tells [color=#000000][font=verdana, arial][size=3]where to start searching in the[/size][/font][/color]"[color=#282828][font=helvetica, arial, sans-serif]123456789000[/font][/color]"
[/list]
IF [b]start_position IS 2 IT WIL RETURN second occurance of '0' [/b][color=#282828][font=helvetica, arial, sans-serif]1234567890[i][u][b]0[/b][/u][/i]0[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif] start_position is -1 it searches for first occurance from backwards(right to left) return [/font][/color][color=#282828][font=helvetica, arial, sans-serif]12345678900"[u][b]0"[/b][/u][/font][/color]

[c3x]

[quote name='charygaru' timestamp='1349376371' post='1302582177']
oh now i get it mama so that same logic is applied to all the columns and every id number with a 0 is returned aa leka omitted aa in the result set, when ur query is used ??
[/quote]
[img]http://lh6.ggpht.com/-DUcF-Vl9sRQ/UGD9ApRDU-I/AAAAAAAAHb8/1Pppqj3ONZM/s150/Brahmi-1.gif[/img]answer vachindi kada vayya... inkendi ee disco

[charygaru]

[quote name='padmasri123' timestamp='1349376447' post='1302582184']

avunu charygaru ...columns kadu rows ki
[/quote]

naaku dyslexia undi mama i cannot tell between certain things without getting confused this being one of them. i meant rows

kaani 0 unna values omitted aa included aa ante edo oikati cheppakunda avunu annav endi kaaka ??? edi anukovaali nenu ippudu

[charygaru]

[quote name='kiran1012' timestamp='1349376546' post='1302582193']

basically instr function syntax : INSTR( source_string, substring , start_position )[list]
[*]Here [b]source_string [/b]is as per ur requirement "[color=#282828][font=helvetica, arial, sans-serif]123456789000[/font][/color]"
[*][b]substring [/b]is is the character string ('0') to be searched for inside of source_string "[color=#282828][font=helvetica, arial, sans-serif]123456789000[/font][/color]"
[*][b]start_position (will be integer value) [/b]tells [color=#000000][font=verdana, arial][size=3]where to start searching in the[/size][/font][/color]"[color=#282828][font=helvetica, arial, sans-serif]123456789000[/font][/color]"
[/list]
IF [b]start_position IS 2 IT WIL RETURN second occurance of '0' [/b][color=#282828][font=helvetica, arial, sans-serif]1234567890[i][u][b]0[/b][/u][/i]0[/font][/color]
[color=#282828][font=helvetica, arial, sans-serif] start_position is -1 it searches for first occurance from backwards(right to left) return [/font][/color][color=#282828][font=helvetica, arial, sans-serif]12345678900"[u][b]0"[/b][/u][/font][/color]
[/quote]


very well explained thanks mama

[c3x]

[quote name='padmasri123' timestamp='1349376447' post='1302582184']

avunu charygaru ...columns kadu rows ki
[/quote]
vallu vaade db tables lo Columns lo values untayi vayya [img]http://lh6.ggpht.com/-DUcF-Vl9sRQ/UGD9ApRDU-I/AAAAAAAAHb8/1Pppqj3ONZM/s150/Brahmi-1.gif[/img]

[padmasri123]

substr lo rasanu kada !=0 dis gives all the rows without zero in the end of ID column

[c3x]

[quote name='charygaru' timestamp='1349376568' post='1302582198']
naaku dyslexia undi mama i cannot tell between certain things without getting confused this being one of them. i meant rows

kaani 0 unna values omitted aa included aa ante edo oikati cheppakunda avunu annav endi kaaka ??? edi anukovaali nenu ippudu
[/quote]
nuvu edi ante ade... vadiley ani indirect ga chepthundu vayya [img]http://lh6.ggpht.com/-DUcF-Vl9sRQ/UGD9ApRDU-I/AAAAAAAAHb8/1Pppqj3ONZM/s150/Brahmi-1.gif[/img]

[charygaru]

[quote name='padmasri123' timestamp='1349376646' post='1302582209']
substr lo rasanu kada !=0 dis gives all the rows without zero in the end of ID column
[/quote]

ya mama chudale thanks for your patience and explanation.

[massraja]

enti ee topic 5 pages poyindhaa.

orey chary nuvvu otti doubt adigava leka job kuda cheyinchestunavaa DB prajala thoo.

[padmasri123]

[quote name='charygaru' timestamp='1349376732' post='1302582218']
ya mama chudale thanks for your patience and explanation.
[/quote]