<div>
Display it where? On your web page, gui application,...?<br />
Which server-side language (Script) do you use? Which DB do you use?<br />
<br />
If you want to crete a query which will collect values of this one column (Slno) and sore it in one single row, it is only to possible to by creating temporary table with as many columns as you query returns rows. And then, to create (build) a query to insert those values into that temp table.<br />
OR to user pivot table. You could use an OLAP (OnLine Analytical Processing) data cube to get PIVOT functionality. &quot;Pivoting&quot; will be supported in Yukon (next version of ms sql server), and &nbsp;i am not sure about Oracle.<br />
<br />
Anyway, to hard task, so If you can skip to do that on sql server - don't do it.
</div>


Display it where? On your web page, gui application,...?
Which server-side language (Script) do you use? Which DB do you use?

If you want to crete a query which will collect values of this one column (Slno) and sore it in one single row, it is only to possible to by creating temporary table with as many columns as you query returns rows. And then, to create (build) a query to insert those values into that temp table.
OR to user pivot table. You could use an OLAP (OnLine Analytical Processing) data cube to get PIVOT functionality. "Pivoting" will be supported in Yukon (next version of ms sql server), and  i am not sure about Oracle.

Anyway, to hard task, so If you can skip to do that on sql server - don't do it.

<div>
<div class="content wysiwyg-content">
i have only one coloumn in a table i want to dispaly all the datas in a row.Name of the table is student which contains only one coloumns slno<br />
Student<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Slno<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5<br />
I want to display them as<br />
slno 1 2 3 4 5
</div>
</div>


i have only one coloumn in a table i want to dispaly all the datas in a row.Name of the table is student which contains only one coloumns slno
Student
           Slno
           1
           2
           3
           4
           5
I want to display them as
slno 1 2 3 4 5

display horizontally records

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.