What will be the Error after executing below query?

select * from employee_master,employee_master;

Answer:

It will throw an error saying:-

Msg 1013, Level 16, State 1, Line 1
The objects "employee_master" and "employee_master" in the FROM clause have the same exposed names. Use correlation names to distinguish them.

So, to work above query, we have to give Alias name as below:-

Select * from employee_master A,employee_master B;
Then it will execute properly and will give us output.