gaps-and-islands
SQL - Finding open spaces in a schedule
I am working with a SQLite database and I have three tables describing buildings,rooms and scheduled events.[详细]
2023-03-09 05:57 分类:问答Delete rows following a duplicate
I have a list of user login and logout stamps. Unfortunately a LOGIN entry might not always be followed by a LOGOUT entry.[详细]
2023-03-08 11:48 分类:问答Need help finding the correct T-SQL Query
I am not quite sure how to go about doing this. Basically I have have a table like this UserIdDateRequestedApproved ApprovedByNotes[详细]
2023-03-08 00:38 分类:问答Get list with start and end values from table of datetimes
Currently i have a table built up like this way DeviceIDTimestampValue ----------------------------------------[详细]
2023-03-06 10:50 分类:问答SQL - Getting next number in line from a Recordset with Gaps in Numbers
I have a SQL Record that has number 开发者_如何学编程that are all out of order (has gaps) for example: 1,2,3,7,9,11.....[详细]
2023-02-27 13:43 分类:问答How do I group on continuous ranges
I know some basic SQL, but this one is beyond me. I have looked high and low but no dice. I need a view of the following data, I can do this in the application layer code. But unfortunately for this p[详细]
2023-02-24 09:26 分类:问答How to find missing rows (dates) in a mysql table?
I have tried several topics like this one: How to find missing data rows using SQL? here, but I couldn\'t make it work in my situation.[详细]
2023-02-21 06:17 分类:问答Select rows where price didn't change
Suppose you have a table like (am using SQL Server 2008, no audit log - table is HUGE): SecID | Date| Price[详细]
2023-02-05 07:30 分类:问答oracle sql query to list all the dates of previous month
Guysi have a requirement to list all the dates of the previous monthlike below 20101201 20101202 20101203[详细]
2023-02-04 09:54 分类:问答SQL Server Data Conversion
I have data in the format: Date, FirstName, LastName, Unit Jan1 , Bob, Guy, Home Jan2 , Bob, Guy, Home Jan3 , Bob, Guy, Home[详细]
2023-02-03 16:18 分类:问答