Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • ALIAS Keyword

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 165
    Comment on it

    ALIAS Keyword:

    It is used to give temporary names to table and columns. It is very useful for situations where column or table names are too long.

    Synatx:

    SELECT columnname AS alias_name FROM tablename;
    

    This syntax is used for giving temporary name to column.

    SELECT columnname(s) FROM tablename AS alias_name;
    

    This syntax is used for giving temporary name to table.

    Example:

    SELECT EmployeeName AS Name FROM Employee;
    

    In this query shorthand(alias) name for EmployeeName is Name.

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: