AS is just a more explicit way of mentioning the alias. SELECT * FROM table t1; or SELECT * FROM table AS t1; both are same