title: Difference between Subquery and Correlated Subquery
body: <p>Is the following piece of SQL Query a normal query or a Correlated Subquery ??</p>
  
  <pre><code>SELECT UserID,
         FirstName,
         LastName,
         DOB,
         GFName,
         GLName,
         LoginName,
         LoginEffectiveDate,
         LoginExpiryDate,
         Password,
         Email,
         ReportingTo,
         Mobile,
         CommunicationPreference,
         IsActive
  FROM   (SELECT row_number() OVER (ORDER BY FirstName) AS Row,
                 UserID,
                 FirstName,
                 LastName,
                 DOB,
                 GFName,
                 GLName,
                 LoginName,
                 LoginEffectiveDate,
                 LoginExpiryDate,
                 Password,
                 Email,
                 ReportingTo,
                 Mobile,
                 CommunicationPreference,
                 IsActive
          FROM   DivakarUserRegistration)  T
  </code></pre>
  
  <p>Also, can someone state the difference between the both</p>