SELECT S.NO||NAME||ID FROM <table

I have the table like this
S.No Name ID
01 Xyz 123
I want the result as
01Xyz123
How to write the query to retrieve the entire row data in a
single column?

Question Posted / g sivanagaraju

1 Answers
4745 Views
I also Faced
E-Mail Answers

Answer Posted / g sivanagaraju

SELECT S.NO||NAME||ID
FROM <table_name>

Is This Answer Correct ?

13 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is union? : Sql dba

1033

What is foreign key and example?

942

What is join view in sql?

949

Explain the components of sql?

1068

What is the basic form of sql query?

948

Which command is used to delete a trigger?

1337

What is interval partition?

1061

Does a primary key have to be a number?

969

How do I restart sql?

979

Write the alter statement to enable all the triggers on the t.students table.

1128

How do I partition a table in sql?

1138

What is primary and foreign key?

1068

Explain the difference between sql and mysql.

1067

How do you explain an index number?

1114

how to delete an existing column in a table? : Sql dba

1010