Sql Experts Oka China Doubt Vayya !

[vizagpower]

oka table lo emp salary per month column undi. so ippudu manaki annual salary of every emp kavalante ela chestam?

[JUJUBI_JULABI]

group on emp name and make a sum

[innovative]

[quote name='JUJUBI_JULABI' timestamp='1355337108' post='1302939228']
group on emp name and make a sum
[/quote]

[iTeachSAP]

month\year ane columun unte.. group by lo ee columns kuda add cheyi ..

Ledhante.. sum(sal) *12 chesi .. per year calculate cheyali ...

[vizagpower]

thanx to all

[Mrlavangam]

date column nunchi year ni extract chesi adi kuda group by lo pettu along with empname and calculate sum(sal)