Multiple choice

Which of the following syntaxes is not correct for column or table aliasing in SQL?

  1. Select id,item,(sp-cp) as profit from product;

  2. Select id,item,(sp-cp) profit from product;

  3. Select id,item,(sp-cp)=profit from product;

  4. Select id,p.item, from product p;

  5. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The oracle database shows an error: FROM keyword not found where expected Option 3 is the correct answer.

Keep practicing — related questions