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 is the use of count (*) in sql?

538


Is sql similar to python?

527


What is break?

612


How to take user input in pl sql?

696


What is minus?

541






What is the difference between count 1 and count (*) in a sql query?

491


Why is sql*loader direct path so fast?

593


What is having clause in sql?

520


What is meant by cursor in sql?

536


How to add, remove, modify users using sql?

551


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

660


What is trigger price?

534


What is the difference between subquery and correlated query?

525


Write a query to find the names of users that begin with "um" in sql?

493


What is the difference between delete, truncate and drop command?

542