ORACLE - PLSQL Challenges - PLSQL Challenge 2 - Find the second highest salary for each department (Comments)

Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image

Close it

Select File

This challenge is about finding second highest salary for each department

Home · Challenge Details · Comments · Solutions · Fans (53) · Preferences

Write a Comment


On which version of Oracle will the solutions be tested? Niladri Biswas posted 2 Years ago Hi I am curious to know on what version of Oracle will the solutions be tested? Oracle 10g or some higher version? It will be helpful to know that in advance as there are some features (e.g. Recursive CTE, Pivot, Unpivot etc. only to name a few) which a...
Sample Script is wrong Niladri Biswas posted 2 Years ago Hi, We cannot use "IDENTITY" for generating sequential numbers in Oracle as we do in Sql server. We have to do so by using Sequence. Steps a) First create a sequence b) Create the table c)Insert record into the table (created at step b) using sequence...

On which version of Oracle will the solutions be tested?