In SQL when we assign the ALIAS to any column or table then we use AS keyword. although we assign the ALIAS with out AS keyword but using As keyword is a explicit way. AS keyword place before the ALIAS Name and after the Column or table name.
For example
SELECT customer_name, SUM(payment) AS "Total" FROM payments
GROUP BY customer-name ;
In this statement Total is ALIAS which is declare with AS Keyword.
we cal also use AS keyword when we assign tha ALIAS to Table:
SELECT A.Name , SUM(A1.Fee) AS "Total Sales"
FROM Student AS A
GROUP BY A.Name ;
In Above statement first AS is used to declare column ALIAS and Second AS is used for assign the ALIAS to Table.
Select Command
Distinct clause with Select Command
Where clause In SQL
Logical Operator in SQL SELECT Statement
IN Operator in SQL
BETWEEN Operator in SQL
Use of Wildcards in SQL
LIKE Operator in SQL
ORDER BY Clause in SQL
GROUP BY Clause in SQL
HAVING Clause in SQL
ALIAS In SQL
AS Keyword In SQL
INSERT INTO Command In SQL
Inserting Record In to a Table Form an other Table In SQL
UPDATE Command in SQL
DELETE Command in SQL
AVG Function in SQL