Skip to main content
54 questions from the last 30 days
Newest Active Bountied Unanswered
0 votes
0 answers
7 views

I have imported the data from the attached Excel file. The dataset currently has the following structure: ISO, Name, 1993, 1994, 1995, …, 2023 Each year is represented as a separate column, and new ...
Gourav Joshi's user avatar
  • 111
0 votes
1 answer
102 views

I need help with an issue regarding date returns in a CURSOR in DB2 for LUW. The Dt_Noformat field returns an incorrect date, while the Dt_Format field returns the date correctly. This problem occurs ...
silvioteles's user avatar
  • 1
0 votes
0 answers
91 views

I created a View with this statement: CREATE OR REPLACE VIEW MyLib.WHERE_IS_SOURCE FOR SYSTEM NAME "SRCMSRCH" (LIBRARY,FILE,...
William Graendel's user avatar
  • 17
Best practices
0 votes
2 replies
52 views

What are the most important SQL skills or concepts I should focus to become job-ready as an aspiring data analyst? I want to understand which techniques are most used in real-world projects and ...
Brandon Browner's user avatar
  • 1
-2 votes
0 answers
39 views

Our platforms team has changed the way in which we install SQL Server patches. This weekend, a number of patches have been applied on SQL Server 2016 and appear to have broken the servers. Database '...
Stevie Gray's user avatar
  • 109
2 votes
3 answers
134 views

I want to simplify (or more accurately, generalize) this query: SELECT * FROM MRE_TABLE WHERE col1 = 'my-data-val' OR col2 = 'my-data-val' -- OR ... there are 68 columns I really do not want to ...
kesarling's user avatar
  • 2,360
2 votes
1 answer
75 views

I'm using the ALL syntax in Apache IoTDB 2.0.6 table model for a query, but the returned result is inconsistent with expectations. Minimal Reproducible Data CREATE TABLE main_data ( `time` ...
Yu Long's user avatar
  • 31
Advice
1 vote
10 replies
167 views

After many hours of research I finally cracked the code to uploading images through POST and inserting them into SQL. index.php: Connect DB file to your index require "db.php"; (prevents ...
Naim Hyun-woo's user avatar
  • 1
0 votes
1 answer
124 views

I have an application that connects to an existing shared database that has some of the data it uses are pass-through views to tables in another schema. The application doesn't care that these are ...
M. Justin's user avatar
  • 23.7k
Advice
0 votes
2 replies
67 views

I've read about environment strategies for data pipelines. The common answers are UAT gets a prod backup restored periodically and DEV gets synthetic data or a manual subset. But nobody addresses how ...
Cervani's user avatar
  • 1
Best practices
0 votes
6 replies
179 views

I'm building a web application that has ~34 independent dropdown lists (e.g. currency codes, country names, user types, example statuses, etc.). Each list has no relation to the others — they're ...
dark night's user avatar
  • 1
Advice
0 votes
12 replies
107 views

I have a table that looks something like: | Device id | Starttime | Stoptime | State | |-----------|-----------|----------|-------| Is it possible to make a MySQL request where, if the latest "...
TheBurnMill's user avatar
  • 23
Advice
1 vote
9 replies
168 views

I need to get the start dates of a partnership in different disciplines where the partnership previously existed but the individuals participated with other partners then resumed their partnership. I ...
Hugh Self Taught's user avatar
  • 43
0 votes
0 answers
51 views

NAME Instance Date val John 1 2019 12Y John 2 2019 32dd John 3 2019 23F John 1 2020 43s John 1 2022 23G Mary ... ... ... How do I convert the table into below? Basically transpose by NAME and DATE and ...
KevinC's user avatar
  • 13
-3 votes
0 answers
122 views

I am trying to count solutions to the N-Queens problem in Oracle using exactly one SQL statement. By N-Queens, I mean: count the number of ways to place N queens on an N×N chessboard so that no two ...
Simon's user avatar
  • 1

15 30 50 per page
1
2 3 4