673,798 questions
Score of -1
0 answers
50 views
Return the next OFF event after each ON event
I'm querying motion sensor data stored in GridDB. Each row represents a sensor state change.
Sample data:
dt
message
2021-06-30 10:00:00
ON
2021-06-30 10:00:13
OFF
2021-06-30 10:04:57
ON
2021-06-30 10:...
- reputation score 1
Best practices
0
votes
3
replies
39
views
Split overlapping date ranges and prioritize one record type over another
I have a table containing effective-dated records. For a given PID, I need to determine the correct CODE for any date based on a priority rule between PCD values.
Sample data:
PID
PCD
STDT
CODE
ETDT
...
- reputation score 163
Advice
0
votes
3
replies
70
views
Replicate SAS Merge happening in loop into Pyspark
I have an use case where I need to replicate a sas behaviour into pyspark. In Sas, the Merge between two datasets are happening and its not 1*1 key merge. Its a m*n key merge involving multiple keys. ...
- reputation score 331
Score of 2
1 answer
135 views
Query that shows if a member meets defined metrics from the metrics table
I am trying to figure out how to write a query that can show me if a member meets defined metrics from our metrics table. There is a table that holds member survey answers and we have business ...
- reputation score 127
Advice
0
votes
7
replies
106
views
Best way to start learning SQL for database design and analysis?
I am new to SQL and I'm currently studying database design and analysis. I understand the basic concepts of databases, but I would like to build a strong foundation in SQL before moving on to more ...
- reputation score 1
Score of -3
0 answers
55 views
Problem facing while migration Data NAV16 to NAV16 in the Database [closed]
I’m currently working on a Microsoft Dynamics NAV 2016 to NAV 2016 data migration project, and I’m facing a challenge where I’d really appreciate some guidance from people who have handled similar ...
- reputation score 1
Advice
0
votes
5
replies
67
views
Clarification on JOIN statements SQL
So, I am taking the Google Data Analytics class and I'm learning about using SQL and BigQuery. Some of these examples got me questioning how they work though. Take this for instance, so I know the ...
- reputation score 1
Score of 1
1 answer
109 views
Why doesn't LIMIT return N rows per device after ALIGN BY DEVICE?
I wanted the latest two load_amp rows for each device in Apache IoTDB 2.0.8 tree model, so I queried wildcard devices with ALIGN BY DEVICE and added ORDER BY TIME DESC LIMIT 2. The result contains ...
- reputation score 29
Score of 4
1 answer
118 views
Why does CASE with a DOUBLE branch and ELSE NULL fail with unknown vs DOUBLE?
I'm cleaning string readings in Apache IoTDB 2.0.8 table model. When txt is not bad, I cast it to DOUBLE; otherwise I return NULL. ELSE null fails with a result-type mismatch, but ELSE CAST(null AS ...
- reputation score 67
Score of -3
0 answers
131 views
Dividing 2 numeric values in SQL e.g. Price / Quantity returns a number in scientific notation [closed]
I am dividing 2 numeric values in SQL, example Price/Quantity, and I get a number in scientific notation. I need to use the result to perform more calculations in Excel, how can I format it?
- reputation score 1
Score of 1
0 answers
105 views
Db2 for i: SQL procedure with SET OPTION COMMIT=*CHG leaves row locked after CALL
I am trying to understand the unit of work and locking behavior of a Db2 for i (ver 7.4) SQL procedure created with SET OPTION COMMIT=*CHG.
Minimal reproducible example:
CREATE TABLE T_TEST_COMMIT (
...
- reputation score 7731
Advice
0
votes
6
replies
149
views
Concat multiple row values into for a single empId
Like I have user Data 50 emp inside each user has different skills 3 rows same user but skill column value is different
I want to concat the skill and display in single row for each user don't want ...
- reputation score 1
Score of -3
0 answers
73 views
Calc with Power not showing correct Value [duplicate]
I have a formula that I am trying to use in SQL and the value I get is different from when used in Excel. Can you see if the SQL needs to be tweaked to get the correct value?
Excel formula - for test ...
- reputation score 1
Advice
0
votes
5
replies
116
views
Group By Help - Msg 8120, Level 16, State 1, Line 1
I'm getting an error saying Service.Name does not exist but I can clearly see it in my table.
Query
SELECT TY.Name
,SER.Name
,PAK.[1_Year]
,PAK.[3_Year]
,PAK.[5_Year]
FROM [...
- reputation score 47
Score of -3
0 answers
66 views
Find the number that appears most often, considering 2 columns [duplicate]
Question from LeetCode SQL #602 using MySQL
https://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends/?envType=problem-list-v2&envId=m8baczxh
My code:
# Write your MySQL query ...
- reputation score 77