Calling East Coast

[google2011]

[quote name='jamajacha' timestamp='1337100136' post='1301801500']
select ename,sal,deptno
from TABLE
where sal in (select max(sal) from TABLE group by deptno);

this shd do it ..
[/quote]

yeah edhi work aitundi kani duplicates unte ela ani thinkin ...
distinct petti chusa kani malli okasari try chesi osta...

[150bryant]

[quote name='Vaampire' timestamp='1337100357' post='1301801515']
bhayya. this wont work.

for example dep1 lo max salary 50k undi, dep2 lo max salary 60k undi anuko,
nee select query lo dep1 lo 50k salary unna vallu vastharu, dept lo 50k or 60k salary unnavallu vastharu
[/quote]
work aithadi mama..
but naaku nee explanation ardhaam kaaledhu...repeat pls
subquery keeps returning the value wit respect to the the condition Max(sal) based on grouped parameter (dept)

[150bryant]

[quote name='google2011' timestamp='1337100385' post='1301801519']

yeah edhi work aitundi kani duplicates unte ela ani thinkin ...
distinct petti chusa kani malli okasari try chesi osta...
[/quote]
iddarki same dept lo sam max salary vasthey ela antaava ?
intht case vaadu ichina basic requisition contradict aithadi...

[Vaampire]

[quote name='jamajacha' timestamp='1337100502' post='1301801522']
work aithadi mama..
but naaku nee explanation ardhaam kaaledhu...repeat pls
subquery keeps returning the value wit respect to the the condition Max(sal) based on grouped parameter (dept)
[/quote]

[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

[Vaampire]

[quote name='jamajacha' timestamp='1337100593' post='1301801525']
iddarki same dept lo sam max salary vasthey ela antaava ?
intht case vaadu ichina basic requisition contradict aithadi...
[/quote]
idhariki max salary unnapudu idharini display cheyyadam lo thappu ledhu kada

[150bryant]

[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]
asalu where sal in 50k 60k 70k gurunchi endhuk matlaaduthunaamu.
all we want is
name deptno sal
babu1 1000 50k
babu2 2000 60k
babu3 3000 70k

ee abv result radaaniki nen ichina query works ani naa peeling..
as of now check cheyalenu..
oka vela emaina prob undhi ankuntey..definite we shd talk abt this...sometime again

[Vaampire]

[quote name='jamajacha' timestamp='1337102425' post='1301801648']
asalu [b] where sal in 50k 60k 70k gurunchi endhuk matlaaduthunaamu[/b].
all we want is
name deptno sal
babu1 1000 50k
babu2 2000 60k
babu3 3000 70k

ee abv result radaaniki nen ichina query works ani naa peeling..
as of now check cheyalenu..
oka vela emaina prob undhi ankuntey..definite we shd talk abt this...sometime again
[/quote]

[b]where sal in (select max(sal) from TABLE group by deptno);[/b]

[b]nenu ichina example lo [/b][b]select max(sal) from TABLE group by deptno; returns (50k,60k,70k) andukey daani gurunchi matladuthunnam.[/b]

pers dept salary
[b]babu1 1000 50k[/b]
babu2 2000 60k
babu3 2000 50k
babu4 3000 70k
babu5 3000 50k
babu6 3000 60k


ee paidi table anukundam.

[b]select ename,sal,deptno
from TABLE
where sal in [b] (50k,60k,70k)[/b];[/b]

nuvvu ichina query run chesthey result motham table vasthundi.

correct me if i am wrong bhayya. please point out chesthunna ani anukoku.
just a usefull disco for me

[150bryant]

[quote name='Vaampire' timestamp='1337102895' post='1301801706']
[b]where sal in (select max(sal) from TABLE group by deptno);[/b]

[b]nenu ichina example lo [/b][b]select max(sal) from TABLE group by deptno; returns (50k,60k,70k) andukey daani gurunchi matladuthunnam.[/b]

pers dept salary
[b]babu1 1000 50k[/b]
babu2 2000 60k
babu3 2000 50k
babu4 3000 70k
babu5 3000 50k
babu6 3000 60k


ee paidi table anukundam.

[b]select ename,sal,deptno
from TABLE
where sal in [b] (50k,60k,70k)[/b];[/b]

nuvvu ichina query run chesthey result motham table vasthundi.

correct me if i am wrong bhayya. please point out chesthunna ani anukoku.
just a usefull disco for me
[/quote]
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.

[littlestar]

[quote name='vishwamithra' timestamp='1337098772' post='1301801437']
ny nunchi pitts then niagara sudu...pitts to niagra to 3 hrs eee..

also pitts lo temple thappa em undadhu...so 6 hrs temple kosame drive seyali nuvvu..ila plan sesuko.
.also ny to dc ki china bus tour drives untai kadha try seyi..vaadu anni sufisthadu..even baltimore lo port kuda cover chesthadu ..aa traffic lo adhe best....

1 day statue of liberty and time square complete seyochu..
[/quote]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

[littlestar]

[quote name='Vaampire' timestamp='1337098727' post='1301801433']
parents us vachara. have good time.
[/quote]
yeah bhayya

[littlestar]

[quote name='google2011' timestamp='1337099073' post='1301801453']


neku correct place

manchiga enjoy cheyi .. cam patkoni pittalni kothulani photos thiyi
[/quote]
avve better

[chicago]

[quote name='Little Star' timestamp='1337097614' post='1301801340']
luray caverns shenandoah park untai VA lo..gurthuchhinai ippude
[/quote]nuvu va lo undey kadha mundhu........

[littlestar]

[quote name='manmadudhu' timestamp='1337100360' post='1301801516']
yellow stone ki tesukuni vellu, n grand canyon,, east coast anna ani anaku....avi manchi places chudataniki
[/quote]west aipoindi last yr..ippudu east

[littlestar]

[quote name='IamGladiator' timestamp='1337099837' post='1301801485']
NJ - Atlantic City,beaches like Sandy Hook etc. and bridge water temple
NYC lo ee 2 shows worth watching Blueman group show [url="http://www.blueman.com/"]http://www.blueman.com/[/url] and Zarkana [url="http://www.cirquedusoleil.com/en/shows/zarkana/default.aspx"]http://www.cirquedus...na/default.aspx[/url]
inkaa opika time unte Boston downtown... Cape Code lo beaches and Whale Watching
[/quote]return VA nundi flying maam...so Boston ante malla 1-2 days waste aithademo ani..

[littlestar]

[quote name='dirty kid' timestamp='1337103474' post='1301801752']
nuvu va lo undey kadha mundhu........
[/quote]yes officer...batch antha gaali dumaaraniki ekakdekkado paddadi.