sql query



1. the output from a table is as follows:
col1
----
a
b
c
d
e
f

6 rows selected.
========================================
2. but i want to display the sql output as:
col1
----
a,b,c,d,e,f

1 rows selected.
===========================================
how do i do that. thanks

.



Relevant Pages

  • comparing two values
    ... A or some other ones may be Col1: A and Col2: A. Values range from A to F. ... What I want to display is: if Col2 is less than Col1 display "Dropped", ... Jerry ...
    (microsoft.public.excel.worksheet.functions)
  • sort to top
    ... Depending on a column value, i want to display the rows. ... That is if the col1 has val1 i want it in the beginning rows of the ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: sql query
    ... but i want to display the sql output as: ... Rene Nyffenegger ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • Re: How to drop a default value for a column
    ... modify (col1 default drop) should work but it didn't ... Kalle ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • Re: Column updating problem
    ... Regards ... Michel Cadot ... Prev by Date: ...
    (comp.databases.oracle.misc)