Julio

• Feb 8th, 2016

 

You need to use a Substring Function, depends of the tool you are using, be in most cases is like this Sub(Colum, Begin, End) --> sub (Input_Colum, 2,4).

Tahir Azuz

• Feb 17th, 2016

 

This is an easy case. we need to sum the data until previous row to get the desired results query can be something like as follows

Code
Select  SUM(col_name) OVER( order by Col_name asc rows preceeding ) 


from table_name;

shivakumar

• Jun 12th, 2017

 

Select Trim(column_name) from table;

Akash

• Jun 24th, 2017

 

Use router {mod(IP,2)=1}

Rajath

• Dec 15th, 2017

 

Use CSUM command