This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.
×
Loading...
Close
Home
Share
Oracle: select distinct name from tablename where salary = (select sum(salary)/count(*) as x from tablename where rownum = 5 group by x order by x);
guoyifan
(ooo)
(#372435@0)
Last Updated: 2002-2-18
This post has been archived. It cannot be replied.
Share
Report
Replies, comments and Discussions:
have a employee table like this, find the 5th highest salary in it
枫下论坛主坛
/
工作学习
/
IT技术讨论