I’ve been playing around with the PIVOT function for a while. I have a table that looks like this Every ClientID is repeated once for each month. Every month new rows are added to the table with a new period associated to the row. It’s an incrementing table. What I need to do is to PIVOT the table…
Tag: sql
Oracle SQL query to get comma-separated string in single query
I have a data which is represented as below: I have a query as follows which has to be tweaked to get parent and child names respectively My output should look as follows: I basically want to split the lk.name based on seperator (,) and 1st string before seperator is parentName and 2nd string after seperator …
PHP MySQL loop through the rows and print date when the date changes
My messages table is like this: This is my query used for fetching messages: I want to use created_at timestamp field to group messages in such a way so that I can display date when the message transactions took place. For example: I therefore want to print a new header containing date each time the date chan…
Sql where Condition execution not working
I have the following query logic Show comments which is not deleted Show comments which is deleted after created, within a timespan of 30 days before today(Today – Createddate <= 30) Below is the logic which I wrote, but I don’t think it is working correct. Answer
How to sum the amount and merge the offers in a single row?
I have table with discount transactions data as below: TransactionID DiscountAmount DiscountOffer S011-T012 50 Jun-21 S011-T012 25 ManagerDisc S011-T025 15 Jul-21 I need to create a table in a way that for a single transaction, Discount amount is summed up and Discount offer is shown side-by-side (maybe with …
How add select in list without join
I don’t need to join in a whole table, but just want a value from the table returned in my select list (but other tables are joined for other items). It’s giving me an error…incorrect syntax near select I’m having trouble searching online for this. Answer Assuming the scalar subquery r…
Mysql query : how to calculate statistic growth rate between two period per category
From this table of dates and categories inputs : I’d like to get these folowing table, showing number of rows per category for each first and second quarter, and the growth of number of rows between second and first quarter, in value, and in percentage – which is a simple statistic table type that…
Sql query for finding specific records from the table based on hierarchy
I am trying to make a SQL Query. So There are 3 sections available,Method 1,2 and 3. If A Group+SG Combination is found anywhere, we take that value based on the following hierarchy: Method3>Method2>Method1. Finally, In the output, we have That particular as Final Group and Final SG, And the value is pi…
how many banks are currently rated B+ or above and when was the last time (dateindex) that they had been below
I have these two tables and im trying to get the dateindex of the last time that the company was rated below a B+. dateindex=19941 which means 1994 quarter 1 This selects all the companies that have B+ or above in q2 2020 And it yields the following How can I add the dateindex the last time it was below
SQL: Return Aggregated Results based on some conditions
I need help with making a conclusion in SQL Server based on some column’s values, like status aggregation sort of. As an example, below is a table containing server tasks and their status. If I want to return the aggregated status of each server here are the rules: if all the server tasks are at status …