Is there any convention to add in a local timezone (whatever the user has set it as) in a database? For example, like I can do the following for UTC time: 2014-01-01 01:02:03Z Is there something like the following to…
Is there a way to run a window function where the partition is for a date column and I need the the values to be aggregated in a weekly interval. For example in this dataset Date Value 01-01-2022 10 02-01-2022…
I have a table with a couple of 100 columns on which I want to use the GREATEST function. How can I prevent putting each and every column name into the query? The columns on which I want to use…
I have a large number of txt files with a single column of data. There are no headers in the files. The data are an email address followed by a : and then a string of varchar, which sometimes includes…
Some databases support literals of the various GEO type, for example in Postgres, you can do: SELECT POINT '1,1'; And in Postgres it enforces the sub-type at the column level: SELECT POINT '1,1' UNION ALL SELECT LINE '0,0,1,1'; ERROR: UNION…
I have the following (simplified) structure of a device and log messages which are attached to a device: CREATE TABLE device ( id SERIAL PRIMARY KEY, name VARCHAR(100), serial_number VARCHAR(20) UNIQUE ); CREATE TABLE error_log ( id SERIAL PRIMARY KEY,…
I have a table that contains students publications like this id student 1 john 2 anthony 3 steven 4 lucille 5 anthony 6 steven 7 john 8 lucille 9 john 10 anthony 11 steven 12 lucille 13 john so the…
It seems this particular topic has quite a bit of traction here, but I have only been able to get one example to work, but I'm not sure if it will work for my use case. Please note I am…
I have a query to compute the 3rd highest salary for an employee as shown below. SELECT MAX(salary) FROM employee WHERE emp_no = 1 AND salary < (SELECT MAX(salary) FROM employee WHERE emp_no = 1 AND salary NOT IN (SELECT…
I am using PostgreSQL. I have two tables. Each having there own metric. I want to sum the metrics having same uid in each table induvidually and show them. Consider I have table A uid metric_1 timestamp a1. 10. x…