I have a schema with sex(m/f),state_name(all states of a country), student_name,and education (phd,ms). I use following query to return total males or females in each category of education for every …
Tag: pivot
SQL Count columns from other columns
I have this view generated after using LEFT JOIN over 2 tables (simplified example). Tables: T1: Id, …other columns not used +—-+—–+ | Id | … | +—-+—–+ | 1 | … | | 2 | … | +—-+-…
SQL SERVER PIVOT like PEPSI comes under year then by months etc.. (refer attached image for a clear idea)
I am new to PIVOT… so i dont know whether is it possible or not with pivot. Here is the table and the sample data i used create table sales_history (brandcode varchar(10) , …
Dynamic pivot unknown number of rows – Sql View
I’m using SQL to create a database VIEW from the table below. ItemCode |BcdName |BcdCode | ————————|——————|————-| 03616006.ERA …
How do I count the customers that made more than a purchase?
I have a table called order that looks like this: I am trying to display: 1.Total count of customers that bought 1 time only (that went to the store in one occasion, it could have been that they bought multiple items but it is only a one time event) 2.Total count customers that bought more than 1 time (that w…
SQLite: Selecting multiple counts from one column
I am running a query with SQLite and am relatively new to this. Glance of my dataset: I want group the results by Col A and then show 3 more columns (mild, moderate, high) and their counts — Here is what I’m looking for: I know how I can select just one of the columns (say, mild), but not sure
MySQL Group by with named columns from grouped data
I’m writing an application to record 10 pin bowling game results. I’ve done the submission bit but I’m stuck on displaying the results. Here is the structure: In the example above I am assuming each person played 3 games, however any number of games could be played. How can I get the data in…
How to combine two queries with case statement
How to combine two queries with case statement query1 query2 Expected output: Answer With conditional aggregation: The conditions where by_user = ‘3’ or where by_user <> ‘3’ are checked with a CASE expression, so they are removed from the WHERE clause.
Parse xmltype into table after pivot xml
i have return XMLTYPE after pivot xml that looks like Ukraine 12345
Assign default values in SQL Server dynamic pivot
Below is pivot query for my requirement. Below is my script for table creation scripts with data. Table_TraineeInfo is candidate registration details table, Table_Batch_Lookup is batch detail when batch start date and end date base on filling in pivot, Table_Attendance_Log is candidate attendance log. My curr…