Posted by surya on 03/20/06 07:08

hello sir,
i have a table emp ,it has three fields one is empno int ,second is
ename varchar(20).
and last is salary ,

emp

empno ename salary
----------- ------------ ---------
1000 suresh 10000
1001 ramesh 20000


i want to add a column name is 'doj varchar ' between columns 'ename'
and 'salary'.
i dont want a add last only , i want to add a column only between
'ename' and 'salary'
give me some example
thanks u sir

[Back to original message]