On Mon, 2005-06-27 at 11:42 -0500, Clay Shannon wrote:
> Is there some kind of syntax in SQL which allows you to select most of the
> columns from a table without selecting them all.
>
> IOW, if you have a table with 25 columns, and you want 22 of them in your
> result set, can you do something like:
>
>
>
> Select (* - SuperfluousVal, SuperfluousVal2, SuperfluousVal3) from .
>
>
>
> .rather than explicitly listing the 22 columns?
>
>
>
> Listing the 22 columns explicitly is a pain; grabbing all 25 using "SELECT
> *" is wasteful.
>
>
>
> Clay Shannon,
>
> Dimension 4 Software