All Questions
318
questions
0
votes
0
answers
41
views
How to configure an external formatter in DBeaver Snap Linux?
I'm trying to configure an external formatter for SQL queries in DBeaver, but I'm encountering a "permission denied" error. I'm not very experienced with the command line and just started ...
2
votes
2
answers
65
views
Postgres truncating timestamptz value to 3 places?
In my postgres database I have a table I'll call users with a timestamptz type column updated_time. When I execute a select statement on this field I will get something like this - '2024-07-01 12:30:...
0
votes
0
answers
46
views
How can I properly use Dynamic SQL queries using dynamic pivoting inside DBeaver's SQL Console?
Currently I have an SQL query where I am pivoting the values of one table and then joining that data with another table. The query works but the problem is that I had to hardcode the pivoting for each ...
0
votes
0
answers
25
views
Reconciliation of two tables in SQL using Dbeaver
I am trying to recon two transactional tables.
Table A is the bank report
Table B is the internal report.
Both tables have a matching primary(external_reference_id) and foreign Key (...
1
vote
1
answer
111
views
"UPDATE Table1 INNER JOIN Table2 …" works with Access but not with UCanAccess
My database, which lives in MS Access and is accessible to DBeaver by the UCanAccess driver, contains two tables, which I'll call Table1 and Table2. I want to update Table1 based on entries in Table2 ...
0
votes
1
answer
73
views
JSON Extraction in SQL
I'm trying to use SQL in DBeaver to query a column containing some JSON values.
The JSON object has the following structure:
[
{"key":"screen_name", "value":{"...
-2
votes
1
answer
55
views
SQL Query not working to get the monday from week number and year
I've been struggling to get the Monday from the week number and year number. Can anyone help? I would prefer that there is no reference made to 1900-01-01 because for 2022 the date that my query ...
0
votes
1
answer
43
views
Comparison operators not functioning properly in SQL
I'm trying to find entries in a table with a "value" greater than 100 million (100,000,000), but my query is returning values that don't fit that criterium. Is there something I'm missing? ...
-1
votes
1
answer
41
views
How do I sum corresponding values of distinct records
So I have to write a query for a table grouping by 5 columns and fetch the sum of one of the columns based on the grouping.
Now, in the database I have duplicate records. So I am getting incorrect sum....
0
votes
1
answer
105
views
Oracle SQL UPDATE Statement, Needs to Begin with SELECT
I have my update script:
UPDATE SCHEMA.TABLE_NAME
SET FLAG = 2
WHERE ID = 'UNIQUE_001'
What I need to do now, is try and get that query to run, with a SELECT statement at the beginning. SELECT needs ...
0
votes
0
answers
41
views
sum(nvl not aggregating properly sql
I am using dbeaver 23.3.3 and I am wondering why my SQL query is not aggregating properly and if anyone knows a fix to this?
Here is my query:
select
weeknum,
year,
coalesce(sum(orders),...
-4
votes
3
answers
126
views
How can I find the latest date where a particular query returns no rows in a table? [closed]
I have a SQL query:
select max(date)
from index_constituents
where (opening_closing ='O'
and index_code ='buk350n'
and issuer = 'cboe') and date = '2024-04-25';
id
date
...
0
votes
2
answers
61
views
Alter the table if table and column exists in MYSQL
I have a function & I'm checking whether the table and column exist or not. If exits, then I need to alter the table.
delimiter $$
create function column_exists(ptable varchar(300), pcolumn ...
1
vote
0
answers
46
views
How can I use a Python dictionary to update values in a Postgres SQL database more efficiently?
I have a python dictionary:
id_to_contract_date = {1: 20242222, 2:20240303, 3:20240404, 102834: 20240505, ...}
My SQL table looks like this:
id fid ts val
1 ...
0
votes
0
answers
32
views
How can I grab a substring of a string value in Postgres SQL, and replace another row with this substring?
I am working with the following table:
id fid ts val
403307394 900 2021-09-20 00:00:00.000 Futures
403307394 901 2021-09-20 00:00:00.000 FSR3 SI ...