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; ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
