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)

Sudheer Vasam · Answer

Alias Name for table #t........ #t t or #t as t

Bikesh Srivastava · Answer

Hi, i am not getting your point ,,what is #tt??????????.