-
hi guys,
pl. find a solution for this :
assuming a simple table, that an emp table has got 3 cols like empno,ename,esal. and contains 10 rows.
if we give select empno,ename,esal from emp;
it will list you all ten rows corresponding to empno.
but i want to see only all empno's in horizontal manner at a time.
ie., not like :
empno
=====
1001
1002
1003
..
..
1010
but i want see them like
empno
=====
1001, 1002, 1003, ....1010
at sql prompt
thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|