Thursday, March 18, 2010

Query to find top 3rd salary in an organisation using RANK function

select empname, salary
from (select empname,salary ,rank() over(order by salary desc) sal_rank from EMPLOYEE)
where sal_rank=3

(From Oracle 9i onwards)

Tuesday, March 2, 2010

About Managed Services(in Telecom)

Major Advantage/Requirement/VAlue add of managed services operations in telecom sector is that service provider are expected to resolve the problems when they arise or to fix faults before the customers or end users realize there is a fault.