On Mon, 30 Jun 2003, Abdul Wahab Dahalan wrote:
> Hi everybody!
>
> I just want to know is there a way in SQL command that can handle column
> selection?.
> The case is :
> If I've a table with 10 columns and I want to select 8 of them without
> rewrite the columns/fields name in the SQL query?
> eg : Current SQL query is :- Select a,b,c,d,e,f,g,h from abctable; -
> greps 8 columns
> Can SQL do something like Select * from abctable without i,j ? -
> greps all 8 columns?
Not really like that, but you can create a view:
create view test as selct a,b,c,d,e,f,g,h from table
then
select * from test;