Question:You want to list names of the employees who have been with the company for more than five years. Which of the following SQL statements will display the required results? 

A SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE>5 
B SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5 
C SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5 
D SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5 

+ Answer
C 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description