I need to fetch data like the below: select u.id from public.user u where u.reporting_id in (select u.id from public.user u where u.reporting_id = ?) is there any best way of doing same in PostgreSQL
I have an postgres table in the below structure I want to write a query which will Delete all the records from the table which are older than 90 days and is in COMPLETE status. if any row has a…
I'm trying to make a custom table widget in filament for showing best selling products. When I do sum(quantity) as total_quantity, it gives me Column not found error. Here's my entire code and the error message : public function table(Table…
In Synapse dedicated pool, I'm trying to create an external table, and a dedicated table, and then insert the external table into the dedicated table but I keep getting the following error: Explicit conversion from data type bigint to date…
I have a table which contains all the Reports report_id | Name ---------------+------------- 1 | Sales Q3 2 | Sales Q2 I have a relation table which contains one to many relations about the report with dept report_id | dept_id…
I have multiple tables with the exact same structure (fields: date, id, revenue). Let’s imagine I have 3 tables, each one with 3 rows to make this simpler. The only thing that changes between each table the is the suffix,…
So, I am doing union on same table, table1 with 2 different set of queries. My first query should return results with type 'test' and 2nd query should return results irrespective of type. But when Iam executing below query my…
I am trying to understand SQL better and have run into a problem when it comes to key-value pairs (I think there is a better term for this, but am not sure). Contract Contract Type Column1 Column2 Contract 1 Type…
Background: The from_current is a year (-2 is 2 years ago and -1 is 1 year ago). The following query is suppose to show the items purchased in each category grouped by 2 years ago and 1 year ago. The…
In mysql, I have a table full of attributes, looking like so: USER_ID ATTR_NAME ATTR_VALUE 1 Name Jess 1 Age 23 1 Sex m 2 Name Jess 2 Age 23 3 Name Ann 3 Sex f (Note that not every…