Question:When running the following SELECT query:
SELECT ID FROM (
    SELECT ID, name FROM (
        SELECT * 
             FROM employee
    )
);
The error message 'Every derived table must have its own alias' appears. 
Which of the following is the best solution for this error? 

A SELECT ID FROM ( SELECT ID AS SECOND_ID, name FROM ( SELECT * FROM employee ) ); 
B SELECT ID FROM ( SELECT ID, name AS NAME FROM ( SELECT * FROM employee ) ); 
C SELECT ID FROM ( SELECT ID, name FROM ( SELECT * FROM employee ) AS T ) AS T; 
D SELECT ID AS FIRST_ID FROM ( SELECT ID, name FROM ( SELECT * FROM employee ) ); 

+ Answer
C 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

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

Description