As shown in figure, how to write a select statement, this kind of data in the table can be on the same line, and at the same time get TXNDATE this column difference, ask the great spirit guide

CodePudding user response:

What kind of result? Use excel,

CodePudding user response:

reference 1st floor selling fruit net reply:

what kind of result? Use excel,

As shown in figure, two rows of data will be merged into the way the data format on the bottom of the query speed slightly faster method excuse me?

CodePudding user response:

In simple terms, is to make two string concatenation,

Listagg this function, at the right moment to solve your problem.

CodePudding user response:

reference 3 floor selling fruit net reply:

simple says, is to take two string concatenation,

Listagg this function, at the right moment to solve your problem,

The desired result is not string together, hope can keep separate each of the different values in a column, the feasible way to excuse me?

CodePudding user response:

If it is not in the same column, which can consider the line "column", baidu first, there is a problem come out,

CodePudding user response:

Give yourself that, isn't there a great god come and look at this issue? Has been a headache for two days, very worried of one thing

CodePudding user response:

https://blog.csdn.net/nayi_224/article/details/85321666

CodePudding user response:

In case the when, as a, b use two tables, trackinlot data from a table and table b match after trackoutlot b table data