Skip to content

Tag: sql

Always round set seconds / minutes /hours to 00 mysql

In my database I have the following date-times: I want to be able to retrieve these records with the hours, minutes or seconds set to their 00 values: For example I want to be able to return records with seconds and milliseconds set to 00: Or return them setting the minutes to zero as well. How can I write a

Conditional Order By in sql server with multiple order columns

i wish to perform conditional order by with multiple columns i am expecting a query like can we achieve this.? sample data result i need is Answer I think this is what you want: Appreciate that when price is NULL, the above reduces to: That is, the alternate CASE expressions just collapse to NULL, leaving the…

Weighted Average of Survey Questions

I have to calculate weighted average for all questions. Assuming there are 22 questions in a survey which has 5 options as 1,2,3,4,5 and NA. For example, 3 people took the survey (all 22 question) Assuming there are 10 NA responses (combined for all 3). So, denominator will be : 22*3 – 10 = 56 Numerator…

Redshift Rounding Off Issue

I have a table which has a numeric(23,2) field that I need to divide to a constant. My baseline is this aggregation select site, sum(sales) / 1.07 as sales from sales group by site; But when I add …

How to parse a json object – mysql

I have a json object like this: {“1”: {“penalty_percent”: 3, “free_day”: 5, “free_hours”: 24}, “2”: {“penalty_percent”: 2, “free_day”: 5, “free_hours”: 12}, “3”: {“penalty_percent”: 2, &#822…