Calling East Coast

[Vaampire]

[quote name='vishwamithra' timestamp='1337099287' post='1301801465']
evari istam valladhi...seffedhi seftham...ardham sesukunte valla adrustam..lekapothe karmaaa...
[/quote]
li8 vayya. mind relax chesukodaniki vasthundochu gaa.

dbing chesthunantha mathrana migithavi pattinchukodam ledhu anukolemu gaa

[Jatka Bandi]

[img]https://lh5.googleusercontent.com/-2kJx7oCkixs/T5UIDLvrB1I/AAAAAAAACf4/eDo9JObAl_s/s320/jaffananda.gif[/img] Jaffananda swamy vari taggariki pattukupo....

[150bryant]

[quote name='google2011' timestamp='1337099207' post='1301801462']
oh ok ok ... nen fine jamajacha,... kaali time lo emaina nerchukovalani undi kani interest ravatledu ... ee madhya koncham work thakkuve undi ..

ninnu adigina interview questions cheppachu kada
[/quote]
tell me about your previous projects..

two table ichadu...result kuda ichadu..
write SQLquery for tht. (ans: left join tables..orderby condition)
another write SQL query for whos got the highest salary in each respective depts (ans: select them for max salary using groupby condition based on dept id)

how do you approach a mapping doc and the related database(ans: chk for table..chk for pkeys chk for count against source target chk for field to field validation)
a little on HP QC and bug reporting.

[google2011]

[quote name='bantrothu bullabbai' timestamp='1337099405' post='1301801468']
[img]https://lh5.googleusercontent.com/-2kJx7oCkixs/T5UIDLvrB1I/AAAAAAAACf4/eDo9JObAl_s/s320/jaffananda.gif[/img] Jaffananda swamy vari taggariki pattukupo....
[/quote]

[google2011]

[quote name='jamajacha' timestamp='1337099513' post='1301801474']
tell me about your previous projects..

two table ichadu...result kuda ichadu..
write SQLquery for tht. (ans: left join tables..orderby condition)
another write SQL query [color=#ff0000]for whos got the highest salary in each respective depts (ans: select them for max salary using groupby condition based on dept id)[/color]

how do you approach a mapping doc and the related database(ans: chk for table..chk for pkeys chk for count against source target chk for field to field validation)
a little on HP QC and bug reporting.
[/quote]


ela cheste duplicates unte ??

[150bryant]

[quote name='google2011' timestamp='1337099645' post='1301801478']
ela cheste duplicates unte ??
[/quote]
select DISTINCT ani ?

[IamGladiator]

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.cirquedusoleil.com/en/shows/zarkana/default.aspx[/url]
inkaa opika time unte Boston downtown... Cape Code lo beaches and Whale Watching

[Anta Assamey]

Parents peru meda nuvvu kuda mottam tirigey....[img]http://i47.tinypic.com/4s086h.gif[/img]

[150bryant]

[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[b] Boston downtown... Cape Code[/b] lo beaches and Whale Watching
[/quote]
NJ nunchi 95 South velaali ankuntundu..not 95 North

[google2011]

[quote name='jamajacha' timestamp='1337099686' post='1301801481']
select DISTINCT ani ?
[/quote]


distinct also i dont think it will work ...
nuv edhe kada cheptundi ??
[size="2"][color="#0000ff"][size="2"][color="#0000ff"]select[/color][/size][/color][/size][size="2"][color="#000000"] [/color][/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]count([/color][/size][/color][/size][size="2"][color="#000000"]*[/color][/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]),[/color][/size][/color][/size][size="2"][color="#000000"] [/color][/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]max([/color][/size][/color][/size][size="2"][color="#000000"]id[/color][/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"])[/color][/size][/color][/size]
[size="2"][color="#0000ff"][size="2"][color="#0000ff"]from[/color][/size][/color][/size][size="2"][color="#000000"] <table>[/color][/size]
[size="2"][color="#0000ff"][size="2"][color="#0000ff"]group[/color][/size][/color][/size][size="2"][color="#000000"] [/color][/size][size="2"][color="#0000ff"][size="2"][color="#0000ff"]by[/color][/size][/color][/size][size="2"][color="#000000"] id[/color][/size]

[size="2"][color="#000000"]ela cheste id ni group by chesinapudu duplicates kuda ostunayi ?? [/color][/size]

[150bryant]

[quote name='google2011' timestamp='1337099951' post='1301801493']


distinct also i dont think it will work ...
nuv edhe kada cheptundi ??
[size=2][color=#0000ff][size=2][color=#0000ff]select[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]count([/color][/size][/color][/size][size=2][color=#000000]*[/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]),[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]max([/color][/size][/color][/size][size=2][color=#000000]id[/color][/size][size=2][color=#0000ff][size=2][color=#0000ff])[/color][/size][/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]from[/color][/size][/color][/size][size=2][color=#000000] <table>[/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]group[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]by[/color][/size][/color][/size][size=2][color=#000000] id[/color][/size]

[size=2][color=#000000]ela cheste id ni group by chesinapudu duplicates kuda ostunayi ?? [/color][/size]
[/quote]
select ename,sal,deptno
from TABLE
where sal in (select max(sal) from TABLE group by deptno);

this shd do it ..

[Vaampire]

[quote name='google2011' timestamp='1337099951' post='1301801493']


distinct also i dont think it will work ...
nuv edhe kada cheptundi ??
[size=2][color=#0000ff][size=2][color=#0000ff]select[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]count([/color][/size][/color][/size][size=2][color=#000000]*[/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]),[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]max([/color][/size][/color][/size][size=2][color=#000000]id[/color][/size][size=2][color=#0000ff][size=2][color=#0000ff])[/color][/size][/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]from[/color][/size][/color][/size][size=2][color=#000000] <table>[/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]group[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]by[/color][/size][/color][/size][size=2][color=#000000] id[/color][/size]

[size=2][color=#000000]ela cheste id ni group by chesinapudu duplicates kuda ostunayi ?? [/color][/size]
[/quote]

select max(salary),dept,count(*)
from table1
group by dept


idhi anukunta athanu cheppindi

[150bryant]

[quote name='google2011' timestamp='1337099951' post='1301801493']


distinct also i dont think it will work ...
nuv edhe kada cheptundi ??
[size=2][color=#0000ff][size=2][color=#0000ff]select[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]count([/color][/size][/color][/size][size=2][color=#000000]*[/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]),[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]max([/color][/size][/color][/size][size=2][color=#000000]id[/color][/size][size=2][color=#0000ff][size=2][color=#0000ff])[/color][/size][/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]from[/color][/size][/color][/size][size=2][color=#000000] <table>[/color][/size]
[size=2][color=#0000ff][size=2][color=#0000ff]group[/color][/size][/color][/size][size=2][color=#000000] [/color][/size][size=2][color=#0000ff][size=2][color=#0000ff]by[/color][/size][/color][/size][size=2][color=#000000] id[/color][/size]

[size=2][color=#000000]ela cheste id ni group by chesinapudu duplicates kuda ostunayi ?? [/color][/size]
[/quote]
Actually Wat sort of duplicates are u talkin abt?
be specific

[Vaampire]

[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]
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

[manmadudhu]

yellow stone ki tesukuni vellu, n grand canyon,, east coast anna ani anaku....avi manchi places chudataniki