close
Skip to main content
673,946 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
-2 votes
2 answers
68 views

I've been learning about COUNT function in SQL. They give me an example but I don't really understand what the COUNT syntax means. Can someone please explain it specifically? This is the code SELECT ...
Laura Ngo's user avatar
  • 1
0 votes
0 answers
42 views

I'm using Apache IoTDB 2.0.8 in table model. I need to filter grouped aggregate results, so I tried to define AVG(voltage) once with the alias avg_v and reuse that alias in HAVING. Schema and original ...
Oliver Svensson's user avatar
  • 9
6 votes
1 answer
129 views

I have a table containing a lot of typed/named items and I want to create a (materialized?) view to group them together so that a UI can later make it easier for users to select. Description The goal ...
Atmo's user avatar
  • 4,290
-3 votes
0 answers
76 views

We are testing a stored procedure that performs insert, update, and delete operations between a source table and a target table, each containing 100+ columns. As part of our test cases, we are ...
vivek vaidya's user avatar
  • 1
0 votes
1 answer
123 views

I have three tables, orders, invoices and invoice lines. uid OrderNumber product_id product_name quantityOnOrder 1 101 p001 Apple 6 2 102 p002 ...
James Smith's user avatar
  • 1
Best practices
0 votes
7 replies
163 views

I am trying to write a basic SQL query that adds two numbers together. While the core arithmetic is straightforward, I want to make sure I am using the standard approach that works across different ...
Kartik Rehpade's user avatar
  • 1
3 votes
4 answers
159 views

Data Set animal legs parrot 2 chicken 2 dog 4 cat 4 c'thulu 999 missing'no 0 Goal animal legs bird 4 mammal 8 I'm not sure what's wrong with my Oracle SQL query. It doesn't seem to be aggregating ...
Joe Liu's user avatar
  • 33
-1 votes
0 answers
84 views

I am using SQLite with DBeaver. I recently got a university assignment where I was asked to show the locking mechanism of a database. So I decided to work with DBeaver. I can solve it properly with ...
MK.Whridoy's user avatar
  • 84
1 vote
2 answers
135 views

I'm creating a query where I have a box, and it has multiple products. I want to check whether any of the products' product_numbers can be found on the addons table. So I initially made this query: ...
user3249400's user avatar
  • 21
0 votes
0 answers
179 views

I've got a query looking for accounts against the user-provided input: SELECT * FROM accounts a WHERE a.dep_id in :depIds AND ( (a.key_identifier IS NULL AND a.name LIKE CONCAT(:searchText, '%...
Sergey Tsypanov's user avatar
  • 4,706
Advice
1 vote
3 replies
155 views

I am currently learning WPF (C#) and trying to build a small Bicycle Management application for practice. I understand the basics individually (WPF controls, simple classes, MySQL connections, etc.), ...
user avatar
1 vote
2 answers
151 views

I'm using SQL Server 2014 so no split string function is available. I have two delimited strings (Brand and Location) to insert in my stored procedure to create (potentially) multiple rows in the ...
Craigjb's user avatar
  • 69
1 vote
2 answers
145 views

I have two tables table testlist20230519_20 cdrid starttime endtime 641EA5F600041BC4 1684425611.337 1684425619.687 641EA5F600041BC5 1684425612 1684425618 641EA5F600041BC6 1684425610.082 1684425617.436 ...
Jackal Dai's user avatar
  • 33
Best practices
0 votes
2 replies
120 views

As a data analyst using Google BigQuery to analyze 2023 weather data for a local news station. You're trying to study the relationship between wind, speed and visibility, but the dataset has missing ...
user32747375's user avatar
  • 1
Advice
1 vote
2 replies
96 views

I have two tables; let's call them table_a and table_b. They look like this: Table_a: id | date ---|----------- A | 2026-05-17 A | 2026-05-01 A | 2026-04-10 B | 2026-05-17 Table_b: id | date ...
SRJCoding's user avatar
  • 543

15 30 50 per page
1
2 3 4 5
…
44930