Help on sql querry

[omegamark]

I need to write a sql querry where is

i need to get the records like

deptno empno empno empno empno
10 23 24 25 27