987184 wrote:This sounds like a job for the analytic DENSE_RANK function.
if there are two salaries are same,then both have to displayed.
987184 wrote:You have unbalanced parentheses. You have 4 left '('s, but only 3 right ')'s
it is displaying as invalid character at sal_rank=2
select salary from (
( select salary
, dense_rank() over (order by salary) as sal_rank
where job_id = 'PU_CLERK'
where sal_rank = 2;
(small letters only, inside curly brackets) before and after each section of formatted text, to preserve spacing. Why do you end the statement with a ';', and then a '/'? Won;t either of them do what you want, without the other? Remember that the default sorting order is <b>ASC</b>ending (smallest first). In this problem, don't you want <b>DESC</b>ending order (largest first)?
can u write the query without using dense_rank() function.Who is "u?"