Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / uma


I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write t..

Answer / g sivanagaraju

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

Is This Answer Correct ?    13 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is an inner join sql?

0 Answers  

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

Describe types of sql statements?

0 Answers  

What do you mean by field in sql?

0 Answers  

What is pragma exception and how, when, where us

5 Answers  




What is benefit of creating memory optimized table?

0 Answers  

What is java sql drivermanager?

0 Answers  

what is heap table? : Sql dba

0 Answers  

What is the use of stored procedures?

0 Answers  

What are different types of sql commands?

0 Answers  

what are the performance and scalability characteristics of mysql? : Sql dba

0 Answers  

What are the two virtual tables available at the time of database trigger execution?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories