1 Reply Latest reply: Sep 10, 2014 7:55 AM by gurjeet singh RSS

    Difference between SQL Select and LOAD

    Laura Sébille

      Hello everyone,

       

      Is there a difference between using

       

      SQL Select

      ....

       

      From Table;

       

      and

       

      LOAD ... ;

      SQL SELECT

      ...

      FROM. Table ;



      when extracting data from a database ?

        • Re: Difference between SQL Select and LOAD

          Select is actual what we are fetch data  from the database or from any other source.

           

          You can not use any function when we are using

          SQL Select

          ....

           

          From Table;

           

           

          If you want to use function to transform the data you need to use LOAD. ...;

           

           

          2.........

          load is always load column from preloaded table i.e. SELECT.

           

          3............

          you can use multiple load for one SELECT.

           

          e.x.

           

          load c1,c4 as c5,*;

          load c1, c2 as c4;

          select c1,c2,c3 from XXX;