I tried
create or replace procedure highest_salary(v_salary out number)
as
v_rnk number;
begin
select d.* from (select rownum rnk into v_rnk from (select distinct salary into v_salary from employees order by salary desc))d
where d.rnk=v_rnk;
end ;
/
i am getting error like this,
LINE/COL ERROR
-------- -----------------------------------------------------------------
5/1 PL/SQL: SQL Statement ignored
5/48 PL/SQL: ORA-01744: inappropriate INTO
kindly tell me the solution , how to make it.