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

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

Ferrari
Yavvanam Kaatesina Bewarse
Username: Ferrari

Post Number: 2097
Registered: 09-2010
Posted From: 117.197.214.252

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

Posted on Saturday, June 25, 2011 - 7:40 am:    Edit Post Delete Post View Post/Check IP
420:

Bedar . lets create a setting and a sitting ...


where? when? how?MOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

420
Bewarse Legend
Username: 420

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

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

Posted on Friday, June 24, 2011 - 12:43 pm:    Edit Post Delete Post View Post/Check IP
Ferrari:

penkul, konchem aa 1 billion row table performance tuning gurinchi konchem explain cheyyundri naa laanti learners ki use avuddi



Bedar . lets create a setting and a sitting ...
Knit India,do not split India !
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 8:36 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:

Gwochi Suzuki

Ferrari:

Gochi Gonzalez



okaremo chinki,inkokaremo makku...asalu bhaasha regional bhedam lekundaa nannu

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

Ferrari
Yavvanam Kaatesina Bewarse
Username: Ferrari

Post Number: 2086
Registered: 09-2010
Posted From: 202.63.112.221

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

Posted on Thursday, June 23, 2011 - 8:06 pm:    Edit Post Delete Post View Post/Check IP
Gochi:


Gochi Gonzalez goruMOVIEART--bemmi.angry
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 4:10 pm:    Edit Post Delete Post View Post/Check IP
Ferrari:

naa laanti experts ki use avuddi



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

Ferrari
Yavvanam Kaatesina Bewarse
Username: Ferrari

Post Number: 2085
Registered: 09-2010
Posted From: 202.63.112.221

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

Posted on Thursday, June 23, 2011 - 4:08 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:


penkul, konchem aa 1 billion row table performance tuning gurinchi konchem explain cheyyundri naa laanti learners ki use avuddiMOVIEART--bemmi.entry
Top of pagePrevious messageNext messageBottom of page Link to this message

Ferrari
Yavvanam Kaatesina Bewarse
Username: Ferrari

Post Number: 2084
Registered: 09-2010
Posted From: 202.63.112.221

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

Posted on Thursday, June 23, 2011 - 4:06 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

India janabha lekkalu storing chese database emo ferrari baa


soothante attaage undi baaMOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Biryani
Yavvanam Kaatesina Bewarse
Username: Biryani

Post Number: 2062
Registered: 10-2010
Posted From: 167.121.100.1

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

Posted on Thursday, June 23, 2011 - 4:03 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

Black_pearl:

Stylestar:


andariki thanks...work avuthundi
World Champions!
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 4:02 pm:    Edit Post Delete Post View Post/Check IP
Ferrari:

1 billion rows aa



India janabha lekkalu storing chese database emo ferrari baa

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

Ferrari
Yavvanam Kaatesina Bewarse
Username: Ferrari

Post Number: 2083
Registered: 09-2010
Posted From: 202.63.112.221

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

Posted on Thursday, June 23, 2011 - 4:02 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:

I helped a candidate on a deadly performance tunning ,on a 1 billion rows table


1 billion rows aaMOVIEART--bemmi.adi
Top of pagePrevious messageNext messageBottom of page Link to this message

Durga
Bewarse Legend
Username: Durga

Post Number: 28101
Registered: 03-2004
Posted From: 207.70.143.185

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

Posted on Thursday, June 23, 2011 - 3:59 pm:    Edit Post Delete Post View Post/Check IP
SQL toputurumkhans anadarru eedane vundaru gaMOVIEART--bemmi.look
*TARAKA*
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 3:56 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:

1 billion rows table



1 billion row count aaa

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

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

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

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

Posted on Thursday, June 23, 2011 - 3:54 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

indulo intha depth undanukoledhu penkulesh...chamincheyyand



Gwochi Suzuki , yesterday I helped a candidate on a deadly performance tunning ,on a 1 billion rows table
Leading Distributor's , humble Leading shoe duster.
Top of pagePrevious messageNext messageBottom of page Link to this message

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1834
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 23, 2011 - 3:49 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

Style baa mee query run chesthe result thappocchindi...



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

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 3:48 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:

Union all merges both results faster than UNION ..



indulo intha depth undanukoledhu penkulesh...chamincheyyandi

MOVIEART--bemmi.look
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: 73532
Registered: 07-2004
Posted From: 148.168.127.10

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

Posted on Thursday, June 23, 2011 - 3:47 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:

what about mine ?



meeru seppaaka inka doubt emundi...correst gaane occhindi result

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

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

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

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

Posted on Thursday, June 23, 2011 - 3:46 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

Style baa mee query run chesthe result thappocchindi...



what about mine ?
Leading Distributor's , humble Leading shoe duster.
Top of pagePrevious messageNext messageBottom of page Link to this message

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

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

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

Posted on Thursday, June 23, 2011 - 3:45 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

union all deniki penkulesh



My past Habit from writing queries for performance , even though I know upper query returns only non null and lower one gets only Nulls. Union all merges both results faster than UNION ..
Leading Distributor's , humble Leading shoe duster.
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 3:44 pm:    Edit Post Delete Post View Post/Check IP
Stylestar:



Style baa mee query run chesthe result thappocchindi...

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

Stylestar
Yavvanam Kaatesina Bewarse
Username: Stylestar

Post Number: 1833
Registered: 01-2009
Posted From: 65.51.27.62

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

Posted on Thursday, June 23, 2011 - 3:42 pm:    Edit Post Delete Post View Post/Check IP
select a.col1, a.col2
from table a
where ( a.col2 is not null
or
(
a.col2 is null
and
not exists
(select 'x' from table b where a.col1 = b.col1 and a.col2 is not null)
)
)
order by a.col1, a.col2
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 3:41 pm:    Edit Post Delete Post View Post/Check IP
Black_pearl:



union all deniki penkulesh

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

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

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

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

Posted on Thursday, June 23, 2011 - 3:40 pm:    Edit Post Delete Post View Post/Check IP
Gochi:

UNION



MOVIEART--avataram
Leading Distributor's , humble Leading shoe duster.
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 3:38 pm:    Edit Post Delete Post View Post/Check IP
SELECT *
FROM t101
WHERE col2 IS NOT NULL
UNION
SELECT *
FROM (SELECT col1, MAX (col2) col3
FROM t101
GROUP BY col1)
WHERE col3 IS NULL
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

Black_pearl
Mudiripoyina Bewarse
Username: Black_pearl

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

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

Posted on Thursday, June 23, 2011 - 3:36 pm:    Edit Post Delete Post View Post/Check IP
select Column1,Column2 from table1 where Column2 is not null
union all
select Column1,Column2 from table1 where Column2 is null and
Column1 not in (select Distinct Column1 from table1 where Column2 is not null )


MOVIEART--bemmi.look
Leading Distributor's , humble Leading shoe duster.
Top of pagePrevious messageNext messageBottom of page Link to this message

Onlyniru3
Bewarse Legend
Username: Onlyniru3

Post Number: 12559
Registered: 08-2009
Posted From: 59.164.51.164

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

Posted on Thursday, June 23, 2011 - 3:32 pm:    Edit Post Delete Post View Post/Check IP
calling 420, stewie, kufli aka dobbey aka vja baaaas
Telugu Jaathi Velugu Rekha ! Telugu Talli Keerthipataaka ! Telugu Atmagouravaprateeka ! Nandamuri Tarakaramudu..
Top of pagePrevious messageNext messageBottom of page Link to this message

Biryani
Yavvanam Kaatesina Bewarse
Username: Biryani

Post Number: 2061
Registered: 10-2010
Posted From: 167.121.100.2

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

Posted on Thursday, June 23, 2011 - 3:16 pm:    Edit Post Delete Post View Post/Check IP
Actual ga oka table emo DB2 inko table emo Terradata ..aa rendu join chesaka ila vasthunnayi results dentlo nunchi kinda cheppinattu konni eliminate cheyyali
World Champions!
Top of pagePrevious messageNext messageBottom of page Link to this message

Biryani
Yavvanam Kaatesina Bewarse
Username: Biryani

Post Number: 2060
Registered: 10-2010
Posted From: 167.121.100.2

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

Posted on Thursday, June 23, 2011 - 3:15 pm:    Edit Post Delete Post View Post/Check IP
Gochi:


edo thondarlo type chesa...ippudu chudu actual req pettanu
World Champions!
Top of pagePrevious messageNext messageBottom of page Link to this message

Tingari_xx
Bewarse Legend
Username: Tingari_xx

Post Number: 41203
Registered: 08-2006
Posted From: 205.157.110.11

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

Posted on Thursday, June 23, 2011 - 3:15 pm:    Edit Post Delete Post View Post/Check IP
null vunde vatiki inko statement raayali afaik...ela rayalo marsifoyaanu though
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 3:14 pm:    Edit Post Delete Post View Post/Check IP
Biryani:

avunu baa



mari alaatappudu A1,A2 rendu endukunnaayi...just A2 undaali kadhaa..nee yenks client requirements lekka piccha clear gaa isthaava reqs

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

Biryani
Yavvanam Kaatesina Bewarse
Username: Biryani

Post Number: 2059
Registered: 10-2010
Posted From: 167.121.100.2

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

Posted on Thursday, June 23, 2011 - 3:12 pm:    Edit Post Delete Post View Post/Check IP
MAx kadu Null kakunda vere values vunte aa values anni ravali only null vunte null ravali
World Champions!
Top of pagePrevious messageNext messageBottom of page Link to this message

Gochi
Bewarse Legend
Username: Gochi

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

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

Posted on Thursday, June 23, 2011 - 3:12 pm:    Edit Post Delete Post View Post/Check IP
Biryani:



ante max value for each category naa...
bongulo signature...manaki avasaramaaa CLIPART--eyebrow_raised_in_disbelief
Top of pagePrevious messageNext messageBottom of page Link to this message

Biryani
Yavvanam Kaatesina Bewarse
Username: Biryani

Post Number: 2058
Registered: 10-2010
Posted From: 167.121.100.2

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

Posted on Thursday, June 23, 2011 - 3:06 pm:    Edit Post Delete Post View Post/Check IP
Naku oka table lo ila vunnayi values

A NUll
A 1
A 2
B Null
C Null
C 1

Itla extract cheyyali ..
A 1
A 2
B Null
C 1

konchem Query help cheyyandi
World Champions!

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