NIELIT 2017 July Scientist B (IT) - Section B: 52

Question

'AS' clause is used in SQL for

• A. Selection operation
• B. Rename operation
• C. Join Operation
• D. Projection Operation

Answer 1

As is used for rename operation in SQL.This is useful when we are using same table multiple times in s query like in case of self join or to rename a column for use in the query.

So B is correct.