Thursday, August 27, 2009

Example-19

Zoho Assignment(Netsalary)

here netslary=salary+comm-tax
tax taken 15%

Zoho Assignment(concat)

here firstname and lastname join to get fullname by using concate function

Zoho assignment(join)

here first column indicate name of employee and second shows corresponding manager

Zoho Assignment(group concat)

Zoho Assignment(maths function)

here functions like sum, avg, min, max, count are used