写一个光标，显示前5名员工的薪水？ [英] write a cursor which will display top 5 salaries employee ?

问题描述

写一个光标，显示前5名工资员工???

write a cursor which will display top 5 salaries employee ???

推荐答案

SQL> DECLAER

CURSOR C1 IS SELECT eno，e_name，dob，gender，sal，deptno，designo，address，city，date_of_join FROM Emp order salaries desc;

eno emp.eno ％type;

e_name emp.e_name％type;

dob emp.dob％type;

gender emp.gender％type;

sal emp.sal％type;

deptno emp.deptno％type;

designo emp.designo％type;

地址emp.address％type;

city emp.city％type;

date_of_join emp.date_of_join％type;

BEGIN

OPEN C1;

LOOP

FETCH C1 INTO

eno，e_name，dob，gender，sal，deptno，designo，地址，城市，date_of_join;

退出时（C1％ROWCOUNT> 5）或（C1％NOTFOUND）;

INSERT INTO Temp VALUES（eno，e_name，dob，性别，sal，deptno，designo，地址，城市，date_of_join）;

COMMIT;

ENDLOOP

关闭C1;

END;

SQL> DECLAER
CURSOR C1 IS SELECT eno,e_name,dob,gender,sal,deptno,designo,address,city,date_of_join FROM Emp order salaries desc;
eno emp.eno%type;
e_name emp.e_name%type;
dob emp.dob%type;
gender emp.gender%type;
sal emp.sal%type;
deptno emp.deptno%type;
designo emp.designo%type;
address emp.address%type;
city emp.city%type;
date_of_join emp.date_of_join%type;
BEGIN
OPEN C1;
LOOP
FETCH C1 INTO
eno,e_name,dob,gender,sal,deptno,designo,address,city,date_of_join ;
EXIT WHEN (C1%ROWCOUNT >5) or (C1%NOTFOUND);
INSERT INTO Temp VALUES (eno,e_name,dob,gender,sal,deptno,designo,address,city,date_of_join);
COMMIT;
ENDLOOP
CLOSE C1;
END;

这篇关于写一个光标，显示前5名员工的薪水？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！