Questions tagged [sql]

Structured Query Language (SQL) is a language for querying databases. Questions should include code examples, table structure, sample data, and a tag for the DBMS implementation (e.g. MySQL, PostgreSQL, Oracle, MS SQL Server, IBM DB2, etc.) being used. If your question relates solely to a specific DBMS (uses specific extensions/features), use that DBMS's tag instead. Answers to questions tagged with SQL should use ISO/IEC standard SQL.

Filter by
Sorted by
Tagged with
-2
votes
0answers
9 views

Date change to previous month

I have date 11/23/2020 I want output as 02/22/2021 because today date is 16th March 2021, if today date is 16th April 2021 then I want result as 03/22/2021 for date 11/23/2020 tried using Datetime ...
0
votes
0answers
11 views

How to get child nodes and flatten the table in spark sql

I have a table with 2 columns in databricks and trying to get all the child nodes of a parent in spark sql. Parent Child A A B B C B D D E Output 1 : Parent Child All_Node ...
0
votes
0answers
14 views

Writing a SQL Server query to unpack XML formatted data into individual colums

I have a table named EventData. This table has a column of XML type, the column name is XmlData. XmlData contains data in the following format: <Data> <Head> <Site>Site1</...
0
votes
1answer
21 views

Canonical way to store reciprocal data sql

I got a lot of instances of the same Class. Now these objects can be linked and this link can have a weight. Like in an undirected graph. Now I want to store the relationship between each two objects ...
0
votes
1answer
17 views

SQL How to find specific value that is not in another result

tldr; I want to filter out result by checking if current result DOES NOT EXIST in another result So currently I have these 2 queries SELECT dosen.nama FROM dosen AS dosen INNER JOIN role as ...
0
votes
1answer
12 views

Maximo/Oracle SQL statement returning unwanted data from joined tables

Pretty sure it's a simple fix, but I'm lost. Trying to pull data from joined tables where there's a checkbox = 1 (gditwocertflag). I only want to see the specific row that's checked. But I'm ...
0
votes
1answer
21 views

Why does my UPDATE query take so long when my SELECT query doesn't?

I am trying to do the following: let's say I have the following SELECT query (please excuse the german column names): SELECT a1.aktivit?ts_id, a1.herkunft_kontakt, a1.aktionsart, a1.aktionstyp, a2....
0
votes
0answers
14 views

Error While Trying to collect the result of a SQL query in SPARK (Scala)

I'm following a basic tutorial in Spark, in which we're asked to import a .csv file into a database, performing a query and collecting the results of that query. To do so, we first create a Persona ...
0
votes
0answers
6 views

Running SQL scripts on Google Cloud

I've created a trigger script for a SQL Server and I want to run it from the file it's in, but I can't find any resources from Google on how that is actually done. Has anyone tried doing this before?
0
votes
0answers
18 views

Confused quetions for Data Query Languages SQL

hi everyone I would to ask about queryLanguage, I have got question like this "You are writing a SQL query to analyze data about recent trampoline sales. The Store_sales table describes the ...
0
votes
1answer
26 views

what does %(parameter)s means here

I have a code snippet like this. I am confused about the use of %()s. If it is used to format parameters, shouldn't we use %(threshold)d for threshold since it's a number? # Join with the courses ...
0
votes
0answers
20 views

do we have conditional insert or update in db2 like we have if else in sql?

I want to check if we already have a record exist in table , if yes then run update query else insert query should be executed in db2 databse.
0
votes
0answers
20 views

Aggregate multiple rows into one

I have a table with ~3 million rows. Many looks like this (sometimes up to a 100 per customerid): Customerid Town E-Mail Address 123 null sample@gmx.de Fakestreet 123 123 New York null null 123 ...
0
votes
1answer
11 views

Best type for ID column in Activity Log table

I need to choose a type for ID column in Activity Log table which would look like this: ID Type UserID User Logged in UUID1 Something happened UUID2 Any thoughts or recommendations?
-1
votes
0answers
40 views

SQL Server column increment by 100.000+ instead of 1

We use SQL Server 2019 and realized that Id column of some tables are increased by more than 100.000 instead of one by one. According to the some report e.g. Identity increment is jumping in SQL ...

15 30 50 per page
1
2 3 4 5
38855
久草视频新免费_日韩视频一中文字暮_欧美三级片