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?
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
what is meant by nl2br()? : Sql dba
How will you distinguish a global variable with a local variable in pl/sql?
Does sql use python?
Does a join table need a primary key?
What are the uses of merge?
How many types of literals are available in pl sql?
What is the difference between microsoft access and sql?
Mention what are the benefits of pl/sql packages?
Do we need commit after truncate?
Is sql a programming?
What is microsoft t sql?
how to get a list of indexes of an existing table? : Sql dba
Can we use two order by clause in query?
which types of join is used in sql widely? : Sql dba
Is full outer join same as cross join?