sqldatabasepostgresqlamazon-redshiftnavicat
PostgreSQL : How do I take multiple rows with values in different columns and combine into one row with all the values on one line?
This is the table I have currently. I would like to combine everything as one event_code and have everything in one line. I checked stack and google and got different answers which doesn't seem to solve my issue.
What I would like to have is
**event_code : fs_rev : hs_rev : pp_rev : mp_rev : gp_rev : in_rev : broker**
LAK180918 : 619500 : 0 : 7000 : 0 : 5000 : 8500 : 17500
I can't seem to find the answer on how to do this, by combining all the columns under one row. Can anyone suggest what i should do?
Solution
You can use Max or Min function. I am assuming you will have only one valid value for each column in the event.
select event_code, max(fs_rev),max(hs_rev),max(pp_rev),max(mp_rev)
,max(gp_rev),max(in_rev),max(broker)
from table
group by event_code
- How can I efficiently convert a bigint into a base 2 string and count the 1s?
- Create Table Computed Value
- How to place FK constraint so that deleting a single FK record DOES NOT delete the primary record
- Why can't I just use "HAVING" clause all the time instead of "WHERE"? It works the same basically if you use it before/without "GROUP BY"
- Remove constraints in sequelize migration
- Calculate Count of true bits in binary type with t-sql
- SQL Server Operating system error 5: "5(Access is denied.)"
- Modelling a Meals / Recipes / Foods database
- Shapiro-Wilk test
- Select rows for a specific date using TIMESTAMP datatype
- How do I DELETE with WHERE and IN using a composite primary key?
- String Matching Struggle
- SQL-Server: Error - Exclusive access could not be obtained because the database is in use
- Apache Spark: "with as" vs "cache"
- What COLLATE should i set to use all kind of possible languages?
- Authenticate from Linux to Windows SQL Server with pyodbc
- SQL query to return total and percentage calculation grouped by day
- MYSQL - SELECT NULL otherwise latest DATE per group
- Add an incremental categorical column
- PostgreSQL Crosstab Query
- WHERE clause that needs to be NULL or NOT NULL
- A mathematical way to divide overlapping time ranges into hours
- Replacing window function OVER() with WINDOW clause reference yields different results
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- Dateadd for moving 7 day avg VS (partition by price order by date rows between 6 preceding and current row)
- SQL Server does not exist or access denied
- Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
- Checking if a value exists in database
- Redshift GROUP BY ALL syntax not supported
- Sum by ID in another table