I am using ASP.NET as a backend to an application to update some data in a separate system's SQL Server. I have a query that needs to insert many rows to a table. In each row, the values being inserted…
I am trying to combine stv_tbl_perm,pg_class and stl_query to get queries ran against tables with 0 rows using EXISTS. Current Query SELECT z.* FROM stl_query WHERE EXISTS ( SELECT b.relname FROM (SELECT db_id, id, name, MAX(ROWS) rows_all_dist, SUM(ROWS) "rows" FROM…
I have a WordPress site with hundreds of posts that have the category 'Uncategorized'. What I need to do is take these 'Uncategorized' posts and assign them to a category by the year they were created. That is, if a…
Please suppose these two tables: users table: id account_id 1 1 2 1 3 1 4 1 user_labels table: id user_id title 1 2 label1 2 2 label2 3 1 label1 4 1 label2 now I want to select users…
I need to convert number to timestamp in PostgreSQL. I got numbers in database as character varying. I have seen there is a lot of solutions for integers but I got decimal numbers and here comes the issue. The max…
this is my first post on stack overflow, so excuse any ignorance of posting etiquette or whatnot. I was working on this leetcode SQL puzzle, and am very confused as to why these two queries give differing results. They seem…
I am in the process of creating stored procedures, and I've noticed that in the existing ones, parameters are declared using the 'identifier' type, which seems to be an outdated practice. I am updating them to use INTEGER type parameters.…
id client_id driver_id city_id status request_at 1 1 10 1 completed 2023-12-23 2 2 11 1 cancelled_by_driver 2023-12-23 3 3 12 6 completed 2023-12-23 4 4 13 6 cancelled_by_client 2023-12-23 5 1 10 1 completed 2023-12-24 6 2 11 6…
I have rewritten the below query from using a correlated subquery to using a LATERAL JOIN. It is now faster, and I would like to understand why? This SO answer says that there is no golden rule and that it…
I have a table that consists information about status of each customer every day. However, due to space saving, I would like to keep that information only if something has changed. More specifically: ID Customer ID Date Status 1 1…