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 March 19, 2011 * SQL Query Help < Previous Next >

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

420
Bewarse Legend
Username: 420

Post Number: 11001
Registered: 12-2006
Posted From: 82.157.134.169

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

Posted on Wednesday, March 16, 2011 - 1:44 am:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

ayina sare anni rows execute ayyevaraku chesi result matuku rownum = 1 anede thesthadi ga ba




MOVIEART--banthi
Knit India,do not split India !
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Yavvanam Kaatesina Bewarse
Username: Vja

Post Number: 1916
Registered: 12-2009
Posted From: 68.229.32.103

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

Posted on Wednesday, March 16, 2011 - 1:32 am:    Edit Post Delete Post View Post/Check IP
MOVIEART--bemmi.adi
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15174
Registered: 06-2004
Posted From: 72.129.47.227

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

Posted on Wednesday, March 16, 2011 - 12:39 am:    Edit Post Delete Post View Post/Check IP
Gochi:

query lo where rownum = 1 padeyyi baa...



ayina sare anni rows execute ayyevaraku chesi result matuku rownum = 1 anede thesthadi ga ba MOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Yavvanam Kaatesina Bewarse
Username: Vja

Post Number: 1914
Registered: 12-2009
Posted From: 68.229.32.103

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

Posted on Tuesday, March 15, 2011 - 11:21 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

query lo where rownum = 1 padeyyi baa...

MOVIEART--ali.kummavga
Strictly Jai Balayya
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 72021
Registered: 07-2004
Posted From: 70.44.12.183

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

Posted on Tuesday, March 15, 2011 - 11:17 pm:    Edit Post Delete Post View Post/Check IP
Sasibabu:

baa.....oka araganta opika pattu.....neekey answer thattudhi.....adhi DB lo post seseyy emmataneyyy



CLIPART--laugh
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 72020
Registered: 07-2004
Posted From: 70.44.12.183

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

Posted on Tuesday, March 15, 2011 - 11:17 pm:    Edit Post Delete Post View Post/Check IP
Ravanabrahma:

ippudu ee query execute chesinappudu t2.id lu chala undochu. avanni process chesi appudu query end avuthundi kada...naku atleast oka t2.id unna sare saripothundi. so ela cheyyali idi?



query lo where rownum = 1 padeyyi baa...

MOVIEART--bemmi.adi
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15173
Registered: 06-2004
Posted From: 72.129.47.227

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

Posted on Tuesday, March 15, 2011 - 10:08 pm:    Edit Post Delete Post View Post/Check IP
Sasibabu:

baa.....oka araganta opika pattu.....neekey answer thattudhi.....adhi DB lo post seseyy emmataneyyyMOVIEART--bemmi.excited



MOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Sasibabu
Yavvanam Kaatesina Bewarse
Username: Sasibabu

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

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

Posted on Tuesday, March 15, 2011 - 9:20 pm:    Edit Post Delete Post View Post/Check IP
baa.....oka araganta opika pattu.....neekey answer thattudhi.....adhi DB lo post seseyy emmataneyyyMOVIEART--bemmi.excited
Entha Chettu Ki Antha Gaaali....proved again and Again
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15172
Registered: 06-2004
Posted From: 72.129.47.227

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

Posted on Tuesday, March 15, 2011 - 8:27 pm:    Edit Post Delete Post View Post/Check IP
naa query 5 sec paduthundi..inka thagginchali antunnaru. MOVIEART--bemmi.abba
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15171
Registered: 06-2004
Posted From: 72.129.47.227

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

Posted on Tuesday, March 15, 2011 - 8:25 pm:    Edit Post Delete Post View Post/Check IP
ippudu query ila undi..


select name
from table1 t1
where exists (select t2.id
from table2 t2
where t2.name = t1.name)

ippudu ee query execute chesinappudu t2.id lu chala undochu. avanni process chesi appudu query end avuthundi kada...naku atleast oka t2.id unna sare saripothundi. so ela cheyyali idi?
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Bewarse Legend
Username: Ravanabrahma

Post Number: 15170
Registered: 06-2004
Posted From: 72.129.47.227

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

Posted on Tuesday, March 15, 2011 - 8:22 pm:    Edit Post Delete Post View Post/Check IP
nenu oka query rasthunna..

aa query run avuthunnappudu atleast one row data vachina sare motham execute cheyyakunda return ayipovali. ela?

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