Information générale
Catégorie:
Codage, syntaxe et commandes
>See, in the last paragraph pasted, where it says "ONLY THE FINAL SELECT CAN HAVE AN ORDER BY CLAUSE. . ."????
>
>By the way, I seem to have had trouble reading today, but I did *not* see anything in the Help specifying that TOP must be in the first. Where did you get that from???
It doesn't say it in clear. But, in the SELECT's syntax/template, "TOP" is in the first SELECT (or, before "UNION", anyway). So, this is where I got it. Still, I agree with your logic: since ORDER BY and TOP are related, etc.
>And I don't really know what you mean by "ORDER BY works fine with SELECT *", since I don't think I ever said there was a problem there.
Oops! My mistake. It should have been "UNION" and not "ORDER BY". Anyway, UNION and TOP work fine with SELECT *.
I wonder how large a complete doc on SELECT would be. I also wonder how many would read it. :) And I wonder how many would know it. :)
Have a nice weekend,
Vlad
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement