|
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
Navigation:
[Reply to this message]
|