select name from table_name order by name

how can we write a column values horizontal by using sql stmt;
ex:
select name from table_name;(actual output)
a
b
c
d
require output is
a b c d

Question Posted / kalaiselvi

Answer Posted / kalaiselvi

Is This Answer Correct ?

1 Yes

12 No

Please Help Members By Posting Answers For Below Questions

What is sql*loader and what is it used for? : aql loader

1090

What are tuples in sql?

1058

Explain table and field in sql?

1006

What is the clause we need to add in function body to return variable?

965

Explain the savepoint statement.

1037

What is a string data type in sql?

956

What is duration in sql profiler trace?

1018

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1212

What is sql query optimization?

1018

how to drop an existing table in mysql? : Sql dba

981

Explain constraints in sql?

977

Is delete faster than truncate?

954

What is the size of partition table?

987

Why stored procedure is better than query?

884

How to load data with sql*loader?

993