PEEPS Top 10 COMM

View All Public Scripts Login to Run Script

Script Name PEEPS Top 10 COMM
Visibility Unlisted - anyone with the share link can access
Description creates a copy of hr.employees as new table, PEEPS runs a query showing how to use FETCH FIRST X ROWS ONLY
Area SQL General
Contributor That Jeff Smith (Oracle)
Created Wednesday March 23, 2016

Statement 1
```
drop table peeps
```
```
Table dropped.
```

Statement 2

create table peeps as select * from hr.employees

Table created.

Statement 3

select employee_id, first_name, last_name, to_char(hire_date, 'DD-MM-YYYY'), salary, commission_pct
from peeps
where commission_pct is not null
order by commission_pct desc
fetch first 10 rows only


EMPLOYEE_ID FIRST_NAME LAST_NAME TO_CHAR(HIRE_DATE,'DD-MM-YYYY') SALARY COMMISSION_PCT
145 John Russell 01-10-2004 14000 .4
156 Janette King 30-01-2004 10000 .35
158 Allan McEwen 01-08-2004 9000 .35
157 Patrick Sully 04-03-2004 9500 .35
146 Karen Partners 05-01-2005 13500 .3
160 Louise Doran 15-12-2005 7500 .3
159 Lindsey Smith 10-03-2005 8000 .3
150 Peter Tucker 30-01-2005 10000 .3
147 Alberto Errazuriz 10-03-2005 12000 .3
148 Gerald Cambrault 15-10-2007 11000 .3

10 rows selected.

EMPLOYEE_ID	FIRST_NAME	LAST_NAME	TO_CHAR(HIRE_DATE,'DD-MM-YYYY')	SALARY	COMMISSION_PCT
145	John	Russell	01-10-2004	14000	.4
156	Janette	King	30-01-2004	10000	.35
158	Allan	McEwen	01-08-2004	9000	.35
157	Patrick	Sully	04-03-2004	9500	.35
146	Karen	Partners	05-01-2005	13500	.3
160	Louise	Doran	15-12-2005	7500	.3
159	Lindsey	Smith	10-03-2005	8000	.3
150	Peter	Tucker	30-01-2005	10000	.3
147	Alberto	Errazuriz	10-03-2005	12000	.3
148	Gerald	Cambrault	15-10-2007	11000	.3

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database