| Author |
Message |
    
Allarodu
Kurra Bewarse
Username: Allarodu
Post Number: 331
Registered: 03-2004
Posted From: 38.118.10.38
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, May 19, 2005 - 8:48 am: |    |
>> Ya aunu ramu garu ippudu entante aaa col1 lo ABC thoni start ayye anni rows kavali....naku
i think this should work
select * from table_name
where substr(col1,1,3) = col2
may be i am posting late 
sorry for that |
Bob
Kurra Bewarse
Username: Bob
Post Number: 507
Registered: 03-2005
Posted From: 220.240.44.49
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 11:50 pm: | |
essavley joku |
Deithadi
Celebrity Bewarse
Username: Deithadi
Post Number: 2769
Registered: 03-2004
Posted From: 69.220.132.107
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 11:48 pm: | |
Deithadi ki saana id lu vuntai,
kani Deithadi mathram okkadei 
google sie, sana info theluthadi |
Bob
Kurra Bewarse
Username: Bob
Post Number: 505
Registered: 03-2005
Posted From: 220.240.44.49
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 11:36 pm: | |
deithadi id oludi? |
Deithadi
Celebrity Bewarse
Username: Deithadi
Post Number: 2768
Registered: 03-2004
Posted From: 69.220.132.107
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 11:32 pm: | |
ala anesaava,
inka neeku, repu
calling bob mama thread lu, email id exchangelu, background lo xyz lu start |
Bob
Kurra Bewarse
Username: Bob
Post Number: 501
Registered: 03-2005
Posted From: 220.240.44.49
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 11:26 pm: | |
sinna ga eragasadivethanav ga ,good boy gudiwada simham sinna |
Deithadi
Celebrity Bewarse
Username: Deithadi
Post Number: 2765
Registered: 03-2004
Posted From: 69.220.132.107
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 11:21 pm: | |
TI mama, nee self sattire adhirindhi po |
Ramu
Mudiripoyina Bewarse
Username: Ramu
Post Number: 4038
Registered: 03-2004
Posted From: 199.244.214.30
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 4:01 pm: | |
racchamass sOdarA,
ramu garu ela unnaru
bAgunnAnu. nuvvelA unnAvu? caduvu elA sAgutOndi? |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 2703
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 3:07 pm: | |
Thanks TI mama, vallu ichina querys work ayiniyyi.... |
Jackson
Celebrity Bewarse
Username: Jackson
Post Number: 10785
Registered: 03-2004
Posted From: 204.69.40.13
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 3:07 pm: | |
Banku mama 
EE weekend call chesta mama.. |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 2702
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 3:06 pm: | |
Thanks Very Much Aw mama and rajamhundry mamalu.,
Iddarivi work chesiniyyi.........
 |
True_indian
Mudiripoyina Bewarse
Username: True_indian
Post Number: 3412
Registered: 03-2004
Posted From: 192.175.182.25
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 3:03 pm: | |
sinna mama
koddiga detail ga post cheyi
i can think |
Rajahmundry
Kurra Bewarse
Username: Rajahmundry
Post Number: 857
Registered: 03-2005
Posted From: 209.172.81.133
Rating:
Votes: 1(Vote!) | | Posted on Wednesday, May 18, 2005 - 3:00 pm: | |
Open challenge to any bewarses.
SQL queries any time any place  |
Rajahmundry
Kurra Bewarse
Username: Rajahmundry
Post Number: 856
Registered: 03-2005
Posted From: 209.172.81.133
Rating:
Votes: 1(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:59 pm: | |
select * from
table_name
where
col1=substr(col2,1,3) |
Andhrawala
Celebrity Bewarse
Username: Andhrawala
Post Number: 6295
Registered: 03-2004
Posted From: 192.58.204.226
Rating:
Votes: 1(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:57 pm: | |
Sinn
do small change
select * from tabname
where col6 like "'" & col3 & "%'"
This should work assuming col6 is like ABCDEF anf col3 is like ABC |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 2701
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:55 pm: | |
Kani AW mama its giving some error aaa eror kooda ardham katalla TOAD lo isthunnannu nenu aa query... |
Andhrawala
Celebrity Bewarse
Username: Andhrawala
Post Number: 6294
Registered: 03-2004
Posted From: 192.58.204.226
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:42 pm: | |
select * from tabname
where col6 like col3 & "%" |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 2699
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:42 pm: | |
Ya aunu ramu garu ippudu entante aaa col1 lo ABC thoni start ayye anni rows kavali....naku |
Racchamass
Mudiripoyina Bewarse
Username: Racchamass
Post Number: 2874
Registered: 01-2005
Posted From: 130.108.129.21
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:42 pm: | |
ramu garu ela unnaru |
Ramu
Mudiripoyina Bewarse
Username: Ramu
Post Number: 4035
Registered: 03-2004
Posted From: 199.244.214.30
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:41 pm: | |
sinna sOdarA,
let's say if your columns look like this:
col1 col2
------ ----
ABCDEF ABC
123456 122
APSRTC APS
ippuDu sariggA nIku kAvalasindi EnTo aDugu? |
Mayadarimalligadu
Pilla Bewarse
Username: Mayadarimalligadu
Post Number: 35
Registered: 05-2005
Posted From: 130.108.129.21
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:40 pm: | |
mari thread esavugaa nuvvu please anna sare nenu seppa
|
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 2698
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:39 pm: | |
Evvaru lera cheppevallu???Urgent ikakda |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 2695
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:37 pm: | |
ninnevadu adigadu ehe d'i |
Mayadarimalligadu
Pilla Bewarse
Username: Mayadarimalligadu
Post Number: 33
Registered: 05-2005
Posted From: 130.108.129.21
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:37 pm: | |
nenu seppa D eyyi |
Sinna
Mudiripoyina Bewarse
Username: Sinna
Post Number: 2693
Registered: 04-2005
Posted From: 130.70.130.244
Rating:N/A
Votes: 0(Vote!) | | Posted on Wednesday, May 18, 2005 - 2:36 pm: | |
Condition entante oka column size 6 inkokadanidi 3...
aaa 3 column lo unna values thoni start ayyi aa 6 column lo unna values vasthayyi.....
i want condition 2 check wether the values in column (3) is equal to values in column(6)....ante starting 3 values same unte chalu...
Any bosy..please.... |
