I have appeared for an interview @ several companies and have observed that few questions pops up every now and then. These questions aren't tricky but still have an ability to throw otherwise brilliant T-SQL scripters of the hook. Thus it is better to prepare for them in advance.
One such question is How can you find the distinct values from a column of a table, (big pause ....wait for it ..) without using DISTINCT ?
Now, why would you want to do that when Microsoft has been generous and has given us DISTINCT clause to use in such situation. Well the answer is because you want that job so either answer it or ....
Given below are the ways that are @ top of my head right now
