Paul Ganainm schrieb:
>>>>SELECT count(*) FROM (SELECT col1, col2 FROM table)
>
> OK, so that's what you call an "inline view" is it?
Yep :-)
> What then is a derived table, or is a derived table just a synonym for
> inline view?
I'm not sure what the "official" name for this is. I have heard both. So
from my point of view a derived table and an inline view are the same.
> What's wrong with SELECT COUNT(col1) FROM table?
>
Nothing. But my statement was just an example to show the syntax.
But sometimes when things get more complicated it *is* very handy, and I
have used it now and then, and wouldn't want to miss it :-)
Thomas