oracle_dba
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.
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)