Lab Sql

In my view, I have an input and select tags for the user to enter a start and end date. When submit… Read more Return Db Results Within Date Range

I have spent days trying to figure out how to add missing dates with the nearest values in Hive wit… Read more Hive Sql Query To Fill Missing Date Values In Table With Nearest Values

This question relates to this post: Split date range into one row per month in sql server But I'… Read more Split Date Range Into One Row Per Month In Sql Server Pt2

I have a table Subscriptions in PostgreSQL 10.5: id user_id starts_at ends_at ------------------… Read more Find Subscribers Who Did Not Resubscribe Within Threshold Of Old Subscription

I have a table tbldeptdivision as follows: ID DEPTID DIVISIONID FROMDATE TODATE REMARKS … Read more Retrieve Data Within A Date Range In Oracle

I have a situation where a single patient can receive multiple services. These services can have o… Read more Determine Contiguous Dates In Sql Gaps And Islands

Here is part of database: SessionID SessionStartTime SessionCloseTime 24 2012… Read more How To Calculate Maximum Incoming Call Peaks?

I need a function in PostgreSQL that accepts a date range and returns the dates inside the date ran… Read more Get Dates Of A Day Of Week In A Date Range