Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
brief description on query Execution
Sudheer Vasam
Jul 30 2016 3:05 AM
242
Reply
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)
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
change the column into row
select second lowest after value