Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Zend Server Interview Question:
How to write a program that performs the calculations using the SQL function?
Submitted by: Administrator- The SQL functions are used to perform the calculations of the statements using the Zend_Db_Select command.
- The expression needs to have parentheses and the command that is given as Zend_Db_Select need to provide the statement appropriately.
- The Zend_Db_Expr is used to explicitly create the expressions that are given below:
$select = $db->select()
->from(array('p' => 'products'),
array(
'product_id',
'cost_plus_tax' => new Zend_Db_Expr('p.cost * 1.08'),
));
Submitted by: Administrator
- The expression needs to have parentheses and the command that is given as Zend_Db_Select need to provide the statement appropriately.
- The Zend_Db_Expr is used to explicitly create the expressions that are given below:
$select = $db->select()
->from(array('p' => 'products'),
array(
'product_id',
'cost_plus_tax' => new Zend_Db_Expr('p.cost * 1.08'),
));
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.