Posts

Showing posts from 2015

Finding Nth Highest Salary of an Employee

-- Find nth highest salary of an employee 1)  Using Corelated Subquery select * from Emp e1 where 1= (select count(distinct(e2.sal)) from Emp e2 where e2.sal>e1.sal); 2)  Using Rownum select * from (select e.*, row_number() over(order by sal desc) rownumb from Emp e where sal is not null) where rownumb=3; 3) Using Rank select * from (select e.*, rank() over(order by sal desc) ranking from Emp e where sal is not null) where ranking =2;

Oracle ADF Beginner Links

Simple Tutorials On Oracle ADF Beginners Peoples(Oracle ADF beginners) who are all passing this street,  here is one way to start with simple start tutorials.  Oracle JDeveloper and Oracle ADF 11g Tutorials Build Rich Client Forms with ADF Swing and ADF Business Components Oracle   JDeveloper   11g   Release   2(11.1.2) Tutorials Oracle   ADF   11g    DeskTop   Integration