What is the difference between Autonomous and correlated subqueries?

Hello,I tried to Google different subqueries, but about "Autonomous" did not really find anything.
As I understand the following query
select e.FIO, e.Schet, s.Salary_data 
from Employee e, Salary s 
where e.Employee_ID = s.Employee_ID and s.Salary_data < 
(select Salary_data 
from Salary 
where Employee_ID = 1);

is correlated
and it looks like a standalone query as it is constructed and what is the difference?
April 3rd 20 at 18:53
1 answer
April 3rd 20 at 18:55
if a subquery uses values from another query, he Correlated subquery
well I gave an example of correlated, I wonder what is Autonomous and how it differs from the correlated - vince_Fahey commented on April 3rd 20 at 18:58

Find more questions by tags SQL Server