> > >

LAMP MCQs

Which of the following queries will correctly retrieve the ages and addresses of those students who have been studying in the school for the last 2 years?

$SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "DATE_SUB(CURRENT_DATE,Interval 2 YEAR)";

$SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "DATE_SUB(CURRENT_DATE,Interval 2)";

$SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "CURRENT_DATE-2";

$SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "Year(CURRENT_DATE)-Year(CURRENT_DATE-2)";

Answer

Correct Answer: $SQL_QUERY="select age,address from student where regdate ="; $SQL_QUERY .= "DATE_SUB(CURRENT_DATE,Interval 2 YEAR)";

Explanation:

Note: This Question is unanswered, help us to find answer for this one

LAMP Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it