Your Ad Here

Tuesday, March 24, 2009

Find Maximum Salary

declare
eno number;
ena char(20);
salary number;
begin
select empno,ename,sal into eno,ena,salary from emp where sal=(select max(sal) from emp);
dbms_output.put_line('salary' || ' = ' || salary);
end;
/

No comments: