Inline vs sub query - techincal difference.
948010Jul 7 2012 — edited Jul 8 2012After searching a lot on net the differences between inline view and sub-query that i came across are
1) you can use order by in inline view but not in sub-query.
2) you can use alias for inline view but not sub query.
But i don't understand/know, that if i have to featch the same outcome using both the functionality respectively, then what is the technical impact/better.