One question, I am confused on this...
select ID, name name from person
select ID ID, name name from person
Both these statements dont give any error message and run successfully...
wht is it so?
Think both statements as the following:
select ID, name [AS] name from person;
select ID [AS] ID, name [AS] name from person
The AS keyword is optional when used for aliases in the SELECT statement.