Home
Q&A
Education
Technology
Credit
General
Health
Insurance
Questions
Ask a Question
How to concatenate multiple rows into a single string in sql
Home
Technology
How to concatenate multiple rows into a single...
asked
Mar 22, 2023
in
Technology
by
JackTerrance
How to concatenate multiple rows into a single string in sql a. COALESCE b. Option 1 & 2 c. None of the above d. STRING_AGG
oracle-interview-questions-answers
1
Answer
0
votes
answered
Mar 22, 2023
by
JackTerrance
How to concatenate multiple rows into a single string in sql Correct answer:- Option 1 & 2
Related questions
0
votes
Q: How to concatenate multiple rows into a single string in sql
How to concatenate multiple rows into a single string in sql a. COALESCE b. STRING_AGG C. Option 1 & 2 d. None of the above...
asked
Feb 19, 2023
in
Technology
by
JackTerrance
oracle-sql-interview-questions-answers
0
votes
Q: How to concatenate text from multiple rows into a single text string in SQL server?
Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into ... Peter, Paul, Mary? Select the correct answer from above options...
asked
Jan 28, 2022
in
Education
by
JackTerrance
sql
sql-server
csv
string-concatenation
group-concat
0
votes
Q: Inserting multiple rows in a single SQL query?
I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and ... a single SQL statement? Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
insert
0
votes
Q: Inserting multiple rows in a single SQL query?
I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and ... a single SQL statement? Select the correct answer from above options...
asked
Jan 26, 2022
in
Education
by
JackTerrance
sql
sql-server
tsql
insert
0
votes
Q: How do you convert single row from source into three rows into target?
How do you convert single row from source into three rows into target?...
asked
Mar 28, 2021
by
JackTerrance
top-informatica-interview-questions
0
votes
Q: SQL Server 2008: how to concatenate values in statement "replace value of"
Here is my test SQL: declare @Table table (strField nvarchar(6), xmlField xml) insert into @Table values ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 23, 2022
in
Education
by
JackTerrance
xml
0
votes
Q: In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a ... A Simple Transaction Model in chapter Transactions of Database Management...
asked
Oct 10, 2021
in
Education
by
JackTerrance
0
votes
Q: Which of these operators can be used to concatenate two or more String objects?
Which of these operators can be used to concatenate two or more String objects? (a) + (b) += ( ... programming questions and answers pdf, java interview questions for beginners...
asked
Oct 25, 2021
in
Education
by
JackTerrance
essential-java-interview-questions
java-interview-questions-answers
java-multiple-choice-questions
java-mcq-with-answers
core-java-mcq
core-java-questions
0
votes
Q: IN and NOT IN operations decreses the performance of an SQL query compared to ANOTHER operations. is it True or FALSE?
IN and NOT IN operations decreses the performance of an SQL query compared to ANOTHER operations. is it True or FALSE? a. TRUE b. FALSE...
asked
Mar 22, 2023
in
Technology
by
JackTerrance
oracle-interview-questions-answers
0
votes
Q: which excel function is used to combine conrents from different cells into one cell?1. concatenate()2. consol()3. void()
which excel function is used to combine conrents from different cells into one cell? 1. concatenate() 2. consol() 3. void() 4.main() Select the correct answer from above options...
asked
Dec 14, 2021
in
Education
by
JackTerrance
computer-science-interview-questions
computer-science-questions
0
votes
Q: How to delete duplicate rows in SQL Server?
How to delete duplicate rows in SQL Server?...
asked
Nov 9, 2020
in
Technology
by
Editorial Staff
interview-question-answer
technology-questions-answers
0
votes
Q: How to fetch rows in column manner in sql?
I have a record in my table like memberId PersonId Year 4057 1787 2 4502 1787 3 I want a result ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked
Feb 21, 2022
in
Education
by
JackTerrance
mysqlsqlsql-serversql-server-2008
0
votes
Q: Views stores the data and you can refresh it on timely bases
Views stores the data and you can refresh it on timely bases a. FALSE b. TRUE...
asked
Mar 22, 2023
in
Technology
by
JackTerrance
oracle-interview-questions-answers
0
votes
Q: Views are created on top of Materialized Views
Views are created on top of Materialized Views a. FALSE b. TRUE...
asked
Mar 22, 2023
in
Technology
by
JackTerrance
oracle-interview-questions-answers
0
votes
Q: Which privilege from the following is used to create a private synonym in another user's schema?
Which privilege from the following is used to create a private synonym in another user's schema? a. CREATE SYNONYM b. ... PUBLIC SYNONYM c. CREATE ANY SYNONYM d. None of the above...
asked
Mar 20, 2023
in
Technology
by
JackTerrance
oracle-interview-questions-answers
...