I have a dataset as follows;
I need to display the data on row per customer as follows;
I'm not proficient at all at sql so any help would be greatly appreciated.
AD
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in TERADATA
- Kafka Connect JDBC Connector not working with teradata
- Spool Space Error while using LEFT JOIN in TERADATA
- Teradata query to Calculate Start and End dates Based on a condition
- whether it is possible to overwrite the result of the UNION operation to the name of the first table
- Failure 2673 The source parcel length does not match data that was defined
- Dynamic starting position in substring and dynamic length
- How to set default role for Teradata User?
- How can I create a secure connection with teradatasql
- issue with case statement
- Visual Studio 2022 connection to Teradata ODBC Driver 17.10 from Server Explorer
- Sql - Rolling up multiple rows to one row
- issue with QUALIFY RANK
- SSIS Teradata connection not appearing when creating new connection manager
- Exception criteria exceeded : CPU time in SAS . How to resolve this error?
- Query usage metadata from Teradata
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The answer to your problem can be solved by unpivoting the data. The UNPIVOT in sql can help but for that need certain info to identify the constraints, How many accounts does one customer can have, If a customer has 2 acct and other has 3 acct so what should be populated for acct 3 column for first customer