Acceding order !!!!!

[#1]

Hi All,

          How to Sort the data in Scripting level

        If suppose i have salary column in my table i calculated Tax based an the column in script itself i need the sort the Tax Column in Acceding order  how we can do

can u suggest me

Thank u

[hic]

The structure of the Load should be

     Load ... Resident ... Order By Tax Asc ;

The Order By clause cannot be used in a "Load ... From"; it must be a "Load ... Resident".

HIC

[nizamsha]

while fetching the data from  data base use order by

or

if u r getting the data from excel use this code

TempTable:

Load

Name,

Salary,

Amt

from ur table;

no concatenate

TableA:

Load

Name,

Salary,

Amt

Resident TempTable order by Amt;

drop table TempTable;

Because as of i know we cant use order by directly,we can use order by in resident only