Following is my quey . The file format is follows -
Name Emp code Basic HRA Bonus
abc 123 50 25 25
I have to copy this file into another file and add 1 extra column which is
GROSS and GROSS = Basic + HRA + Bonus ( picture clause of all the amounts is same s9(9) v comp3 ) . The layout of output will be as follows -
Name Emp code Basic HRA Bonus GROSS
abc 123 50 25 25 100
In short can we add some columns within 1 single row thru sort? If yes , How?