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

Answer Posted / kalaiselvi

select name from table_name order by name

Is This Answer Correct ?    1 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does select count (*) mean in sql?

552


What is cursor and its types?

561


What is sql constant?

509


What is tuple in sql?

547


Why use stored procedures?

576






Explain ddl statements in pl/sql?

578


What is dml and ddl?

527


How do you respond to dementia behavior?

533


What are the various levels of constraints?

666


how to create a test table in your mysql server? : Sql dba

498


how do you control the max size of a heap table? : Sql dba

538


Is sql workbench free?

536


What is primary key sql?

546


How can the performance of a trigger be improved?

592


What is substitution variable?

583