Sudhir_N wrote:Don't be ridic; of course there's input. The data in yur check_points table is the input to this query. Post CREATE TABLE and INSERT statements so that people can re-create a version of your table, with just a few rows. Include only the columns that play some role in this problem.
There is no input here only the output has to be provided in column fashion.
Eg: select name from employeesIt sounds like you need String Aggregation .
Thanks will result to
I required out put wht i need is the rows should in column wise
i.e ABC XYZ TTD