What’s the purpose of SQL keyword “AS”?

by

There is no difference between both statements above. AS is just a more explicit way of mentioning the alias

More Related Contents:

  1. How do I create a parameterized SQL query? Why Should I?
  2. Auto Increment after delete in MySQL
  3. SELECT * EXCEPT
  4. Update table values from another table with the same user name
  5. Select max value of each group
  6. Using an Alias in a WHERE clause
  7. How can I define a composite primary key in SQL?
  8. How do I delete from multiple tables using INNER JOIN in SQL server
  9. Does Foreign Key improve query performance?
  10. SQL query for finding records where count > 1
  11. SQL Server convert string to datetime
  12. What is the equivalent PostgreSQL syntax to Oracle’s CONNECT BY … START WITH?
  13. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  14. Return number of rows affected by UPDATE statements
  15. SQL speed up performance of insert?
  16. SQL Server: Cannot insert an explicit value into a timestamp column
  17. Error: Column does not exist
  18. Execute Dynamic Query with go in sql
  19. TransactSQL to run another TransactSQL script
  20. DROP FUNCTION without knowing the number/type of parameters?
  21. How to Concatenate Numbers and Strings to Format Numbers in T-SQL?
  22. How can I get a list of element names from an XML value in SQL Server
  23. SQL server identity column values start at 0 instead of 1
  24. SQL method to replace repeating blanks with single blanks
  25. How can I get multiple counts with one SQL query?
  26. Find records where join doesn’t exist
  27. How do I view grants on Redshift
  28. How to subtract 30 days from the current date using SQL Server
  29. PostgreSQL: top n entries per item in same table
  30. How to do a case sensitive GROUP BY?

Leave a Comment