Skip to Main Content

SQL Query

289018Nov 22 2004 — edited Sep 22 2008
SQL> select ename from emp where job='CLERK';

ENAME
----------
Smith
Adams
James
Miller

SQL> select ename from emp where job='SALESMAN';

ENAME
----------
Allen
Ward
Martin
Turner

SQL> select ename from emp where job='MANAGER'
2 /

ENAME
----------
Jones
Blake
Clark


I need a SQL query to get data in this format .

CLERK SALESMAN MANAGER
----- -------- ---------
Smith Allen Jones
Adams Ward Blake
James Martin Clark

thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Oct 20 2008
Added on Nov 22 2004
2 comments
1,035 views