Calling East Coast

[chicago]

ma vadu enka akade unattunadu.......fafamu......

[littlestar]

[quote name='dirty kid' timestamp='1337103717' post='1301801788']
ma vadu enka akade unattunadu.......fafamu......
[/quote]mee vaadu ante....naam kya hein uska

[Vaampire]

[quote name='jamajacha' timestamp='1337103158' post='1301801724']
kaani manaki max 60k or 70 k ani teliyakapotey em chesthaaam ?
all we gotta use is max(sal) antheykadha..
nen mention chesina query givesout only three rows with max sal and dept and name.
[/quote]
bhayya nenu example tho clear gaa cheppa bhayya. naa example lo edaina miss avuthey cheppu.

ikkasa nuvvu subquery [b]where sal in (select max(sal) from TABLE group by deptno[/b]
use chesav kada. daani place lo inner join cheyyali anukuna

inner join temp table vachesi [b](select [/b][b]deptno,[/b][b]max(sal) from TABLE group by deptno)[/b]

[b]inner join [/b][b](select [/b][b]deptno,[/b][b]max(sal) sal from TABLE group by deptno)temp[/b]
[b]on (temp.sal = [/b][b] table1.sal and temp.deptno = table1.depto)[/b]

sql install chesi ledhu bhayya naa lappy lo. so syntax thappu undochu. concept mathram correct anukuntunna
correct me if i am wrong

[dkchinnari]

[quote name='Little Star' timestamp='1337103314' post='1301801735']
thanks darling..actual ga VA nundi Pitts anukunna..travelling ke 11-12 hours aithundi..adi kuda temple okkate untadi..so kind of optional unde..

ippudu extra 2 hrs lo I am able to cover pittsburg
[/quote]kudirithe pitts nunchi 1hr lo iskan temple untadhi,,west virgina..adi kuda sudu.chala baguntundhi temple...

[k2s]

[littlestar]

[quote name='vishwamithra' timestamp='1337104808' post='1301801908']
kudirithe pitts nunchi 1hr lo iskan temple untadhi,,west virgina..adi kuda sudu.chala baguntundhi temple...
[/quote]India ki pothe nannu gudilaki thipputharu..ikkadiki vachhinaka kuda anni gudile ante thidthaermo

[dkchinnari]

[quote name='Little Star' timestamp='1337104974' post='1301801930']
India ki pothe nannu gudilaki thipputharu..ikkadiki vachhinaka kuda anni gudile ante thidthaermo
[/quote] agrredd..nenu anduke maa prents ni tisukellale .

parents nj lo unde vallu vachinappdu..so friday nite akakda greyhounds ekktieh nenu mrning pick sesukunaa...saturday niaragara complete ayindhi..so sunday temple inka..rides ki ellam ala ayindhi..

[Vaampire]

[quote name='Little Star' timestamp='1337104974' post='1301801930']
India ki pothe nannu gudilaki thipputharu..ikkadiki vachhinaka kuda anni gudile ante thidthaermo
[/quote]
exactly. maa dad ni aurora temple ki veldama ani adigithey pandaga roju patha chinthakaya pachadi enduku raa annadu.

india lo lenivi choopinchu bhayya.
temples anni india loney baguntayi kada ikkadi kantey

[google2011]

[quote name='Vaampire' timestamp='1337101621' post='1301801586']

[b][color=#282828][font=helvetica, arial, sans-serif][size=3]select ename,sal,deptno[/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=3]from TABLE[/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=3]where sal in (select max(sal) from TABLE group by deptno);[/size][/font][/color]

[color=#282828][font=helvetica, arial, sans-serif][size=3]this shd do it ..[/size][/font][/color][/b]



[color=#282828][font=helvetica, arial, sans-serif][size=3](select max(sal) from TABLE group by deptno)[/size][/font][/color]

[color=#282828][font=helvetica, arial, sans-serif][size=3]for example, dep1 lo max salary 50k undi, dept2 lo max salery 60k, dept3 lo max salary 70k undi[/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=3]appudu [/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3](select max(sal) from TABLE group by deptno) returns (50k,60k,70k)[/size][/font][/color]

[b][color=#282828][font=helvetica, arial, sans-serif][size=3]select ename,sal,deptno[/size][/font][/color][/b]
[b][color=#282828][font=helvetica, arial, sans-serif][size=3]from TABLE[/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=3]where sal in[/size][/font][/color][/b][color=#282828][font=helvetica, arial, sans-serif][size=3](50k,60k,70k)[/size][/font][/color]

[color=#282828][font=helvetica, arial, sans-serif][size=3]idhi avuthundi nuvvu raasina query.[/size][/font][/color]
[color=#282828][font=helvetica, arial, sans-serif][size=3]dep2 max salary 60k. kaani dept2 lo 50k salary tho kooda janalu undochu kada. paina query lo aa janalu kooda vastharu. but they are not supposed be there kada.[/size][/font][/color]

dep3 lo 50k,60k tho unna janalu kooda vastharu
[/quote]
[quote name='Vaampire' timestamp='1337101748' post='1301801595']
idhariki max salary unnapudu idharini display cheyyadam lo thappu ledhu kada
[/quote]

GP

[google2011]

[quote name='jamajacha' timestamp='1337100268' post='1301801511']
Actually Wat sort of duplicates are u talkin abt?
be specific
[/quote]


vaampire cheppadu kada ... ala jamajacha... chustuna nen kuda ... google lo chuste chala vachayi ... trying..

[Gachibowli_Diwakar]

CST reporting [img]http://lh4.ggpht.com/-woPP55h9IQA/TwKOVXeQr7I/AAAAAAAAF2s/3_PsrAEFGJw/s150/Brahmi-10.gif[/img]

[Vaampire]

[quote name='google2011' timestamp='1337105903' post='1301802106']


vaampire cheppadu kada ... ala jamajacha... chustuna nen kuda ... google lo chuste chala vachayi ... trying..
[/quote]
em vachayo ikkada pettu. maaku kooda help avochu

[littlestar]

[quote name='vishwamithra' timestamp='1337105552' post='1301802039']
agrredd..nenu anduke maa prents ni tisukellale .

parents nj lo unde vallu vachinappdu..so friday nite akakda greyhounds ekktieh nenu mrning pick sesukunaa...saturday niaragara complete ayindhi..so sunday temple inka..rides ki ellam ala ayindhi..
[/quote]
I hate rides ..rides ante bhayam anuko
[quote name='Vaampire' timestamp='1337105669' post='1301802060']
exactly. maa dad ni aurora temple ki veldama ani adigithey pandaga roju patha chinthakaya pachadi enduku raa annadu.

india lo lenivi choopinchu bhayya.
temples anni india loney baguntayi kada ikkadi kantey
[/quote]dance floor lu..casino lu..camping lu..

[Vaampire]

[quote name='Little Star' timestamp='1337107956' post='1301802440']
I hate rides ..rides ante bhayam anuko
dance floor lu..casino lu..camping lu..
[/quote]
pubs, casina aithey poyinam. masthu enjoy chesindi. mummy india vellipoyaka evari maata vinaledhu.

[littlestar]

[quote name='Vaampire' timestamp='1337108045' post='1301802451']
pubs, casina aithey poyinam. masthu enjoy chesindi. mummy india vellipoyaka evari maata vinaledhu.

[/quote]
back to bachelors life aa