Tag: pivot

Pivot table in SQL Server 2016

datetime pivot sql sql-server window-functions

I am having problem with pivoting a table in SQL Server 2016. Consider the following data/query WITH DATA1 AS ( SELECT 123 cid, ‘test’ cname, ‘2020-03-17’ dt, ‘BELLE’ fc, 3782703 mn union …

2 dimensional table query with join and PostgreSQL [closed]

count inner-join pivot postgresql sql

Trying to return a 2 dimensional table from SQL query (Postgres). Read about Pivot Table (but not sure if it is valid for join) and crosstab/tablefunc but no luck. Expected result App A | …

Counting values within the same row in SQL Server

count pivot sql sql-server unpivot

My SQL Server problem is as follows: let’s say we have clients and we wish to rate them based on 4 categories (Score_1…Score_4) on a scale of 0 to 2. I have a table presented below: What I want my code to do is count the number of 0, 1, and 2 values each of my clients recieved. The result

Is there a way to dynamically execute queries in SQL without using user defined function?

datetime pivot sql sql-server sum

I am currently working on the table containing some documents data, focusing on the columns containing date of document and net income. What I have to do is to write an sql statement which will result …

Is there a way to return non existent values when using groupby and union all?

datetime mysql pivot sql sum

I have a table that I’m trying to return summarized results from for a chart that will have two datasets, one for debit transactions that have happened each month and one for payments that have happened each month. The table I’m querying looks like this: What I’m looking to get back out of m…

SQL pivot query to get the result in a single row

mysql pivot sql

I have a users table as I have another user_custom_fields table as and a third custom_fields table Here the problem is I need the result for each user in a single row with all the custom field_name as column header as I have heard about pivot queries but I don’t have much knowledge of SQL. Can anyone he…

SQL PIVOT-WINDOW FUNCTIONS

pivot sql sql-server window-functions

With the sql query I get table 1 table 1 Trying to pivot using window functions below on Server 2012 fails My desired output Answer Use conditional aggregation Also, you can try with pivot –

Create an insert to pivot value pair values into a table

create-table mysql pivot sql sql-insert

I have a value pair table that I want to use to create a member table Based on Taryns answer to this question MySQL pivot table query with dynamic columns I have this code that creates selects the …

How query two different Sum from the same table for the same column but with different condition?

case mysql pivot sql sum

I would like to fetch the sum of field TOTAL for active users and sum of field TOTAL for inactive users. Expecting is the query that results activeTotal = 15 and InactiveTotal = 50 SELECT SUM(actUser.total) as activeTotal, SUM(inActUser.total) as inactiveTotal FROM user actUser JOIN user inActUser ON inActUse…