brief description on query Execution

Question

Hi to All..........

I have a Table like this (Table Name #t)

Name    sub    marks

Raj       Tel       21

Raj       Hind    22

Raj       Eng      23

Raj       Math    19

vasu      Tel       19

vasu       Hind    21

vasu       Eng       15

vasu       Math       25

 

 

when i executing below Queries

1.select (select distinct Name from #t where Name=t.Name)Name

from #t t

2.select Name from #t t where Name=t.Name

 

Results Will be Same............

i.e

Name

Raj

Raj

Raj

Raj

vasu

vasu

vasu

vasu

 

what is the function of             t.Name (it will loop or grouping)