In SQL select statement, one of the keyword is ‘FROM’. Why FROM is needed. It is the area you need to give source details. That means from which table or view you need to get the data.
So for good. Let us take an example…
SELECT NAME FROM UPFALL WHERE ID=2;
This query does retrieve data from UPFALL table or view where the matching column, i.e. id=2.
The other point is how to refer same table column name using alias. This way of writing SQL query avoids confusion that the column belongs to which table.
Do not worry, I will tell this concept with an awesome example.
SELECT U.NAME (SELECT COUNT (*) FROM UPFAL U2 WHERE U2.CONTRY_ID = U.CONTRY.ID) FROM UPFALL U;
Here, you should not write the above query without using SQL alias. Here, the alias are ‘u, and u2’.
Since in the above query we are referring same columns of the same table. Also, this is one of the co SQL interview question of ambiguous column error.
The result you will get is names who are having same country id. This SQL query is most interesting and also very important for SQL developers.