- ABS(number)

Returns the absolute positive value of an expression.
Syntax:
ABS(expression)
Example:
SELECT ABS(-1.0), ABS(0.0), ABS(1.0)
Output:
1.0    .0    1.0

- CEIL(number)

Returns the smallest integer greater than, or equal to, the specified numeric expression.
Syntax:
CEILING(expression)
Example:
SELECT CEILING($223.45), CEILING($-223.45), CEILING($0.0)
Output:
224.00    -223.00        0.00

- FLOOR(number)

Returns the largest integer less than, or equal to, the specified numeric expression.
Syntax:
FLOOR(expression)
Example:
SELECT FLOOR($223.45), CEILING($-223.45), CEILING($0.0)
Output:
223.00      -224.00        0.00

- MOD(number, divisor)

Returns the remainder of the division from 2 integer values.
Syntax:
MOD(dividend, divisor)
Example:
SELECT MOD(20,3)
Output:
2

- POWER(number, power)

Returns the exponential value for the numeric expression.
Syntax:
POWER(number, power)
Example:
SELECT POWER(2.0, 3.0)
Output:
8.0

- SIGN(number)

Returns the sign i.e. positive or negative value for the numeric expression. It returns -1 for negative expressions, a value of 0 for zero
Syntax:
SIGN(number)
Example:
SELECT SIGN(4)
Output:
1

- ROUND(number, precision)

Returns the numeric value rounded off to the next value specified.
Syntax:
ROUND(number, number of places)
Example:
SELECT ROUND(1.3456, 2)

- SQRT(number)

Returns the square root value of the expression.
Syntax:
SQRT(number)
Example:
SELECT SQRT(4.0)
Output:
2.0

- TRUNC(number, precision)

Returns a numeric value that truncate to the specific places
Syntax:
TRUNCATE(number,places)
Example:
SELECT TRUNCATE(1.3456, 2)
Output:
1.34

Sequence numbers can be generated in Datastage using certain routines. They are

-KeyMgtGetNextVal

-KeyMgtGetNextValConn

SELECT COUNT(*), sex from Employees  WHERE  DOB BETWEEN ‘01/01/1960 ' AND ‘31/12/1975’  GROUP BY sex;

Let the fixed expenditure of the hotel be Rs.x and the variable expenditure ( which is dependent on the guest ) is Rs.y , then 

          x + 10y = 600        ---------(1)

          x + 20y = 800       ----------(2)

From (1) & (2)

10y = 200 

=>  y = Rs. 20   and    x= 400

Hence the total expenditure when there are 40 guests = 400 + 40 x 20 = 1200

Therefore,  average expenditure = 1200/40 = Rs. 30

     D _  C  _ A          --------(1)

     D > B > C           --------(2)

from (1) and (2)

     D > B > C > A   ---------(3)

Again      E _ B _ A

But B > A, from (3)

So          E > D > B > C > A      [ Since B is the average of E and A so it is eqidistant from both E and A]

The 5 consecutive odd numbers whose average is k are  (k-4), (k-2), k, (k+2), (k+4)

Again the average of (k-4), (k-2), k, (k+2), (k+4), (k+6), (k+8) is (k+2)

Use unitary method:

In  hours, 123 typists can type 984 paper

In 1 minute, 123 typists can type   = 246 papers

In 1 minute, 1 typist can type  =2 papers      [ Hint  hours = 4 minutes]

Let,   B1 : B2 : B3 = 3x : 4x : 5x 

again  B1 : B2 : B3 = 5y : 4y : 3y

Since there is increase in no.of oranges in first two baskets only, it means the no. of oranges remains constant in the third basket

Therefore,   5x = 3y

Hence    3x : 4x : 5x   =>   9y5:12y5:15y5 = 9y:12y:15y

and       5y : 4y : 3y   =>   25x : 20x : 15x

Therfore, increment in first basket = 16

Increment in second basket = 8

Thus, required ratio = 16/8 = 2:1