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 November 11, 2011 * SQL Help < Previous Next >

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

Dobbey
Kurra Bewarse
Username: Dobbey

Post Number: 3765
Registered: 03-2011
Posted From: 65.204.218.243

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

Posted on Thursday, November 10, 2011 - 3:22 pm:    Edit Post Delete Post View Post/Check IP


Stewie:

Ravana babai.. doubts manaki be be.. artham kaavu chaala mattuku




aayankai kochen adagadame atta aduguthadantaava MOVIEART--bemmi.ok
Health is Happiness
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 75544
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Thursday, November 10, 2011 - 3:16 pm:    Edit Post Delete Post View Post/Check IP


Stewie:

select t1.name from
(select t1.name count(t1.name) from t1, t2
where t1.city = t2.city
and t2.country = 'India' group by t1.name) A,
(select distinct count(city) cnt from t2 where
country = 'India') B
Where a.cnt = b.cnt

Ila emanna try cheyyi gochi ba..




thanks Stewie baa,it worked CLIPART--hug1 solution DB lo dorikindhi ani chepthe maa colleagues shock ayyaaru...ilaati telugu technical DB's kooda unnaayani maaku asalu thelavadhu ani CLIPART--biggrin
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 731
Registered: 03-2011
Posted From: 99.32.132.46

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

Posted on Thursday, November 10, 2011 - 11:59 am:    Edit Post Delete Post View Post/Check IP


Dobbey:

naaku telsu vayaa nuvvu osthavani egeskoni




Gochi ba ani help chesa.. Ravana babai.. doubts manaki be be.. artham kaavu chaala mattuku :P
kothga petta signature ela undi CLIPART--new
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger

Post Number: 6501
Registered: 06-2005
Posted From: 77.168.111.63

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

Posted on Thursday, November 10, 2011 - 11:48 am:    Edit Post Delete Post View Post/Check IP

Chass I am driving !.. my fingers are itching
kanapade nijam: Good manners , kanapadanidhi: abusive language
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Kurra Bewarse
Username: Dobbey

Post Number: 3752
Registered: 03-2011
Posted From: 65.204.218.243

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

Posted on Thursday, November 10, 2011 - 11:34 am:    Edit Post Delete Post View Post/Check IP


Stewie:



naaku telsu vayaa nuvvu osthavani egeskoni MOVIEART--bemmi.siggu
Health is Happiness
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 730
Registered: 03-2011
Posted From: 99.32.132.46

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

Posted on Thursday, November 10, 2011 - 11:32 am:    Edit Post Delete Post View Post/Check IP

select t1.name from
(select t1.name count(t1.name) from t1, t2
where t1.city = t2.city
and t2.country = 'India' group by t1.name) A,
(select distinct count(city) cnt from t2 where
country = 'India') B
Where a.cnt = b.cnt



Ila emanna try cheyyi gochi ba..
kothga petta signature ela undi CLIPART--new
Top of pagePrevious messageNext messageBottom of page Link to this message

Kubang
Pilla Bewarse
Username: Kubang

Post Number: 657
Registered: 09-2011
Posted From: 68.147.147.218

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

Posted on Thursday, November 10, 2011 - 11:02 am:    Edit Post Delete Post View Post/Check IP


Gochi:

title soosi hemu anukuneru..




exactly ade anukunna gosendraMOVIEART--ali.lol
Devuda, be ready
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17690
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, November 10, 2011 - 11:00 am:    Edit Post Delete Post View Post/Check IP

nenu cheppindi boothu anukunta MOVIEART--bemmi.laugh
Top of pagePrevious messageNext messageBottom of page Link to this message

Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma

Post Number: 17689
Registered: 06-2004
Posted From: 98.151.191.253

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

Posted on Thursday, November 10, 2011 - 10:59 am:    Edit Post Delete Post View Post/Check IP

sub query rayochemo gochesh...manager sir vachelopu okati cheptha try cheyy..


select person from
t1, (select city from t2
where state = 'India') a
where t1.city = a.city

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

Pokiri1
Mudiripoyina Bewarse
Username: Pokiri1

Post Number: 18345
Registered: 03-2006
Posted From: 192.91.147.34

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

Posted on Thursday, November 10, 2011 - 10:33 am:    Edit Post Delete Post View Post/Check IP

hemu ekkada vunna ikkadiki raavali. E query teesukelli mee DB lo vesi answer pattuku raa tondara gaa.ikkada elago adaga ledu kada
ara nimashamulo sachevadivi nee address naku endhuku raa
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

Post Number: 75540
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Thursday, November 10, 2011 - 10:23 am:    Edit Post Delete Post View Post/Check IP

title soosi hemu anukuneru...konchem urgent andukane nenesaa CLIPART--a140

oka table lo ilaa unnai values.. T1

A, Chennai
A, Hyd
A, Guntur
B, Chennai
B, Hyd

second table lo inkoka lookup undi..T2

Chennai - India
Hyd - India
Guntur - India

ippudu India lo all 3 locations ki evadiki access undho vaalle raavali final output lo...B gaadu raakoodadhu,bcos he has only access to 2 cities in India and not all of them


MOVIEART--bemmi.adi

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