Need help in formatting the displayed result [message #267720] |
Fri, 14 September 2007 06:27  |
vamsikgummadi
Messages: 62 Registered: April 2006 Location: United States, MI
|
Member |
|
|
Hello friends,
I am working on a project and I need help from you all.
Explanation of the query:
SELECT * FROM EMP E, DEPT D
WHERE E.DEPTNO=D.DEPTNO
GROUP BY D.DEPTNO
After execution of the result I may get the o/p as follows:
Empno ename deptno
1 Scott 10
2 woods
3 john 20
5 williams
8 james
10 remo
11 stella 40 Now the problem is I need to display my result in the manner given below:
empno ename deptno
1 2 scott woods 10
3 5 8 10 john williams james remo 20
11 stella 40
Is there any way to display the result in the above mentioned format? If yes, please send me the code snippets for displaying the result in this format. Please don't use concatenation because I need to display all these values in separate cells. Once if you can help me I can use the same in my project and there after push this data to data grid.
Hope you can solve this and forward your suggestions.
Thanks and regards,
Vamsi K Gummadi.
[Updated on: Fri, 14 September 2007 07:35] by Moderator Report message to a moderator
|
|
|
|