Salary & Govt. Concessions for a Member of Parliament (MP)

You can just cross verify the content of this page from http://parliamentofindia.nic.in/ls/intro/p8.htm ,

a government website page. The facilities mentioned

below are the summary of this page only.

Monthly Salary: Rs. 12,000/-

Expense for Constitution per month: Rs. 10,000/-
Office expenditure per month: Rs. 14,000/-

Traveling concession (Rs. 8 per km): Rs. 48,000/-

(eg. For a visit from South India to Delhi & return: 6000 km)

Daily DA TA during parliament meets: Rs. 500/day

Charge for 1 class (A/C) in train: Free (For any number of times)
(All over India )

Charge for Business Class in flights: Free for 40 trips / year (With wife or P.A.)

Rent for MP hostel at Delhi: Free.
Electricity costs at home: Free up to 50,000 units.

Local phone call charge: Free up to 1, 70,000 calls.

TOTAL expense for a MP [having no qualification] per year: Rs.32, 00,000/-

[i.e. 2.66 lakh/month]
TOTAL expense for 5 years: Rs. 1, 60, 00,000/-

For 534 MPs, the expense for 5 years:
Rs. 8,54,40,00,000/-

(Nearly 855 crores)

AND THE PRIME MINISTER IS ASKING THE HIGHLY QUALIFIED, OUT PERFORMING CEOs TO CUT DOWN THEIR SALARIES.....

This is how all our tax money is been swallowed and price hike on our regular commodities.........

And this is the present condition of our country:

855 crores could make their life livable!!
Think of the great democracy we have…

add to del.icio.us saved by 0 users

SQL Statement to get the 2nd highest salaried/paid Employee.

Best Solution:

select *
from emp
where sal =
(
select max(sal)
from emp
where level=2
connect by prior sal>sal
)
;

SQL Statement to get Nth highest salaried/paid employee(s)

Best.

select *
from emp
where sal =
(
select max(sal)
from emp
where level=&level
connect by prior sal>sal
)
;

Other Solutions
1.)

select *
from emp
where sal=
(
select sal from
(
select rownum Row1,sal
from (
select distinct(sal) sal
from emp
order by sal desc
)
)
where row1=&level
)

2.)

Select empno,ename,job,sal,comm,deptno
from (
select em.*,dense_rank() over
(
partition by grp order by sal desc
) as topsal
from (
select 1 as grp,e.* from emp e
) em
)
where topsal=&topsal

add to del.icio.us saved by 0 users

Few stills from My College Days

add to del.icio.us saved by 0 users