Why can't a subquery of a view have an order by clause?Similarly why one cant change/delete a row through a view when 1)group by is used in view 2)distnct is used in view
+2
A:
ORDER BY generally orders the result set (i.e. columns after first select before FROM), never the subqueries.
Subqueries are used to qualify, not to order results.
Kb
2010-04-24 14:23:56
Similarly why one cant change/delete a row through a view when1)group by is used in view2)distnct is used in view
2010-04-24 14:36:00
@APC - You are right. I also deleted my false comment... ;))
Kb
2010-04-24 14:43:29