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 14, 2011 * SQL help < Previous Next >

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

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 65
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Thursday, March 10, 2011 - 12:03 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

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

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, March 10, 2011 - 11:58 am:    Edit Post Delete Post View Post/Check IP
Onlymovies:

but inta chinna logic ki inta pedda Q's rayalantaava>? deenikante simple ga raaya lema?



ante mana stewie neeku

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

Sachinfan
Celebrity Bewarse
Username: Sachinfan

Post Number: 9233
Registered: 10-2010
Posted From: 71.171.101.88

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

Posted on Thursday, March 10, 2011 - 11:37 am:    Edit Post Delete Post View Post/Check IP
Dobbey:

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

Dobbey
Pilla Bewarse
Username: Dobbey

Post Number: 73
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Thursday, March 10, 2011 - 11:37 am:    Edit Post Delete Post View Post/Check IP
Sachinfan:

baa naaku kuda nerpinchavaa

MOVIEART--dobbeyi
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachinfan
Celebrity Bewarse
Username: Sachinfan

Post Number: 9232
Registered: 10-2010
Posted From: 71.171.101.88

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

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

baa naaku kuda nerpinchavaaMOVIEART--blessme
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 63
Registered: 03-2011
Posted From: 170.136.110.10

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

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

stewie baa.. once again thanks baa..


No worries amma.. you are elcome. MOVIEART--shy
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20986
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Thursday, March 10, 2011 - 9:47 am:    Edit Post Delete Post View Post/Check IP
Black_pearl:

bedar ... I was joking eee .. I do not know SQL as such ..

MOVIEART--bemmi.adi
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20985
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Thursday, March 10, 2011 - 9:47 am:    Edit Post Delete Post View Post/Check IP
Stewie:

stewie baa.. once again thanks baa..
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

Post Number: 2929
Registered: 05-2010
Posted From: 82.157.134.169

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

Posted on Thursday, March 10, 2011 - 8:42 am:    Edit Post Delete Post View Post/Check IP
Onlymovies:

konchem aa Query edo ikkada iste use chesukuntaam



bedar ... I was joking eee .. I do not know SQL as such ..
UTTHAMA ABHIRUCHI Association Pessident ..
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 62
Registered: 03-2011
Posted From: 72.193.147.101

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

Posted on Thursday, March 10, 2011 - 8:39 am:    Edit Post Delete Post View Post/Check IP
Musicfan:

stewie tarapuna naaku

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

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20978
Registered: 01-2009
Posted From: 69.250.64.167

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

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

yes .. you can with one single query ..

konchem aa Query edo ikkada iste use chesukuntaam
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Sachinfan
Celebrity Bewarse
Username: Sachinfan

Post Number: 9194
Registered: 10-2010
Posted From: 71.171.101.88

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

Posted on Thursday, March 10, 2011 - 12:10 am:    Edit Post Delete Post View Post/Check IP
Dobbey:

MOVIEART--dobbeyi
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Pilla Bewarse
Username: Dobbey

Post Number: 67
Registered: 03-2011
Posted From: 68.229.32.103

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

Posted on Wednesday, March 09, 2011 - 11:40 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:

you can with one single query ..

MOVIEART--kota.why
Top of pagePrevious messageNext messageBottom of page Link to this message

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

Post Number: 2921
Registered: 05-2010
Posted From: 82.157.134.169

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

Posted on Wednesday, March 09, 2011 - 11:32 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:

deenikante simple ga raaya lema?



yes .. you can with one single query ..

MOVIEART--bwalk
UTTHAMA ABHIRUCHI Association Pessident ..
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20975
Registered: 01-2009
Posted From: 128.235.31.59

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

Posted on Wednesday, March 09, 2011 - 9:15 pm:    Edit Post Delete Post View Post/Check IP
Musicfan:

MOVIEART--bemmi.sarle
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Musicfan
Bewarse Legend
Username: Musicfan

Post Number: 35479
Registered: 05-2004
Posted From: 98.243.24.34

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

Posted on Wednesday, March 09, 2011 - 9:14 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:

Thanks alot baa... both the queries worked perfectly fine...



fine ante saripodu, consultation fees pampuko OMesh,, stewie tarapuna naaku
RDB Magic
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Pilla Bewarse
Username: Dobbey

Post Number: 65
Registered: 03-2011
Posted From: 68.229.32.103

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

Posted on Wednesday, March 09, 2011 - 9:14 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

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

Dobbey
Pilla Bewarse
Username: Dobbey

Post Number: 64
Registered: 03-2011
Posted From: 68.229.32.103

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

Posted on Wednesday, March 09, 2011 - 9:13 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:

but inta chinna logic ki inta pedda Q's rayalantaava>? deenikante simple ga raaya lema?



ade anukunnam baa.. inko way undochu kaani ittaa vachindindani
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20974
Registered: 01-2009
Posted From: 128.235.31.59

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

Posted on Wednesday, March 09, 2011 - 8:45 pm:    Edit Post Delete Post View Post/Check IP
Stewie baa...
Thanks alot baa... both the queries worked perfectly fine...

but inta chinna logic ki inta pedda Q's rayalantaava>? deenikante simple ga raaya lema?
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20973
Registered: 01-2009
Posted From: 69.250.64.167

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

Posted on Wednesday, March 09, 2011 - 8:30 pm:    Edit Post Delete Post View Post/Check IP
Stewie baa.. ee queries try chesi choostaa
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20972
Registered: 01-2009
Posted From: 69.250.64.167

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

Posted on Wednesday, March 09, 2011 - 8:29 pm:    Edit Post Delete Post View Post/Check IP
Stewie:


but star2 acted in DEF too , so thats not right ?? correct example cheppu ba ?

sorry ba..
DEF lo star2 row vundakooodadu..
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Wednesday, March 09, 2011 - 7:44 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:

1. I want to get the all the star_names, who acted atleast all the movies in which star_1 acted.



Bemmanadam..

ee madhyana anni bommallo untunnaadu..

Onlymovies:

2. I want to get the all the star_names, who acted exactly in all the movies in which star_1 acted.



null...

andaru herolu anni cinemaallo undaru

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

Dobbey
Pilla Bewarse
Username: Dobbey

Post Number: 62
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 6:46 pm:    Edit Post Delete Post View Post/Check IP
MOVIEART--kummesana
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 61
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 6:45 pm:    Edit Post Delete Post View Post/Check IP
Stewie:



2) select def.star_name from
(select count(movie_name ) count1, star_name from table1 where star_name = 'star2'group by star_name) ABC,
(select count(b.movie_name) count2, b.star_name from table1 b , (select distinct movie_name,star_name from table1 where star_name = 'star2' ) a
where a.movie_name = b.movie_name
group by b.star_name
) DEF,
(select count(distinct movie_name) count3,star_name from table1 group by star_name ) EFG
where ABC.count1 = DEF.count2
and efg.star_name = def.star_name
and efg.count3 = ABC.count1
and def.star_name <> 'star2'
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 60
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 6:27 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:

I want to get the all the star_names, who acted exactly in all the movies in which star_1 acted.

Onlymovies:

2. star2



but star2 acted in DEF too , so thats not right ?? correct example cheppu ba ?
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Pilla Bewarse
Username: Dobbey

Post Number: 60
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 6:02 pm:    Edit Post Delete Post View Post/Check IP
query lo 1) enti ani adagamaaku OM ba MOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 59
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 6:02 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:



ba nee kosam table create chesi chesa

1) select def.star_name from
(select count(movie_name ) count1, star_name from table1 where star_name = 'star1'group by star_name) ABC,
(select count(b.movie_name) count2, b.star_name from table1 b , (select distinct movie_name,star_name from table1 where star_name = 'star1' ) a
where a.movie_name = b.movie_name
group by b.star_name
) DEF
where ABC.count1= DEF.count2
and def.star_name <> 'star1'
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20971
Registered: 01-2009
Posted From: 128.235.31.59

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

Posted on Wednesday, March 09, 2011 - 4:51 pm:    Edit Post Delete Post View Post/Check IP
Stewie:

Ivi try cheyyi ba.. pani cheyyakaa pothe cheppu table create chesi try chesta

idi work avvaledu bayya..
anni records vastunnayi, for both the queries.. and also result lo 4 columns vastunnayi
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 58
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 1:09 pm:    Edit Post Delete Post View Post/Check IP
Vammo mental pressure pettaru.. urgent ga na query check cheyyali aagu :-)
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20968
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Wednesday, March 09, 2011 - 1:01 pm:    Edit Post Delete Post View Post/Check IP
Dobbey:

SQL guru maa vadu

MOVIEART--bemmi.prayer
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Dobbey
Pilla Bewarse
Username: Dobbey

Post Number: 53
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 12:53 pm:    Edit Post Delete Post View Post/Check IP
Onlymovies:

Thanks baa.. table into laptop lo create chesa.. evening check chesi cheptaa..



damn sure work avuthaadi

nakoka query kaavalante raasichaadu ipude manoduu
SQL guru maa vadu
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20967
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Wednesday, March 09, 2011 - 12:52 pm:    Edit Post Delete Post View Post/Check IP
Stewie:

Ivi try cheyyi ba.. pani cheyyakaa pothe cheppu table create chesi try chesta

Thanks baa.. table into laptop lo create chesa.. evening check chesi cheptaa..
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Vja
Yavvanam Kaatesina Bewarse
Username: Vja

Post Number: 1912
Registered: 12-2009
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 10:59 am:    Edit Post Delete Post View Post/Check IP
Stewie:

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

Stewie
Pilla Bewarse
Username: Stewie

Post Number: 57
Registered: 03-2011
Posted From: 170.136.110.10

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

Posted on Wednesday, March 09, 2011 - 10:58 am:    Edit Post Delete Post View Post/Check IP
select * from (select distinct movie,star_name from table where star_name = 'star_1')a , table b where
a.movie = b.movie(+)

----
select * from (select distinct movie,star_name from table where star_name = 'star_1')a , table b where
a.movie = b.movie


Ivi try cheyyi ba.. pani cheyyakaa pothe cheppu table create chesi try chesta
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20964
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Wednesday, March 09, 2011 - 10:20 am:    Edit Post Delete Post View Post/Check IP
emiti, evariki teliyadaa? no SQL experts here?
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20949
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Wednesday, March 09, 2011 - 8:59 am:    Edit Post Delete Post View Post/Check IP
Don:

kotha website build chestunnava OMesh..

MOVIEART--bemmi.adi
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Don
Bewarse Legend
Username: Don

Post Number: 16236
Registered: 12-2004
Posted From: 205.132.110.2

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

Posted on Wednesday, March 09, 2011 - 8:57 am:    Edit Post Delete Post View Post/Check IP
kotha website build chestunnava OMesh..
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20945
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Wednesday, March 09, 2011 - 8:49 am:    Edit Post Delete Post View Post/Check IP
kinda data consider cheste

1. star2 and star3

2. star2
answers
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20944
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Wednesday, March 09, 2011 - 8:47 am:    Edit Post Delete Post View Post/Check IP
movie star_name

ABC star1
ABC star2
ABC star3
XYZ star1
XYZ star2
XYZ star4
XYZ star3
DEF star2
DEF star3
KLM star4
KLM star5
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlymovies
Bewarse Legend
Username: Onlymovies

Post Number: 20943
Registered: 01-2009
Posted From: 199.173.226.229

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

Posted on Wednesday, March 09, 2011 - 8:45 am:    Edit Post Delete Post View Post/Check IP
i have a simple SQL question..

i have a table with 2 columns lets say

movie_name , star_name.
both columns together is primary key.

1. I want to get the all the star_names, who acted atleast all the movies in which star_1 acted.
2. I want to get the all the star_names, who acted exactly in all the movies in which star_1 acted.
Prati malupunu gelichina gurutuga.. Mailu rallapai santakaalu cheyyanaa..

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