I have a post table that stores the most liked comment (top_comment). I need an SQL statement that updates the top_comment when a comment is liked/unliked: UPDATE post SET top_comment = T1.body FROM ( SELECT body FROM comment WHERE count_like…
I am new to SQL and trying to manipulate some basic data. My schema is: CREATE SCHEMA dannys_diner; SET search_path = dannys_diner; CREATE TABLE sales ( "customer_id" VARCHAR(1), "order_date" DATE, "product_id" INTEGER ); INSERT INTO sales ("customer_id", "order_date", "product_id") VALUES…
I have played around with this for a few hours and it seems to be going over my head. I am a novice at SQL and am attempting to create a simple function to concat first_name and last_name rows into…
I have query in linq and I want to convert that query in sql I am not very good in linq so can anyone help me to convert this query in sql: We have ticket table and issues table ticket…
I'm trying to write a query that involves a join on JSON array. Following are the tables PROPOSAL Table: id details 1 {units: [1, 2]} 2 {units: [1]} UNITS Table: id DMA_ID 1 1 2 2 DMA Table: id name…
I have this table named issue with thousands of rows: id status listPosition 43 New 0 44 New 0 45 New 0 46 Accepted 0 51 Accepted 1 54 Accepted 0 66 processing 0 68 processing 0 I want to…
How can I write down the condition so that he counts the months for me from a certain client (redirect) and source (source)? I need to know how many invoices were issued, and this is counted by month, type January…
This query works in Oracle please let me know how to extract text in postgresql Select regexp_sustr('abc,afgg,afff,eef esfg eg,gegg,egegeg,vgb,grgg','[^,]+',1,5)
I was reading a query that had the all keyword within a function call: select count(all 97); ┌───────────┐ │ count(97) │ ╞═══════════╡ │ 1 │ └───────────┘ Elapsed: 11 ms What does all (outside a subselect) do in postgres? I was…
I'm just learning SQL, using Postgres. I have fruit sales data, how can I retrieve fruit that is only sold from the certain date to another date. I use a query like this but error SELECT product_name, min (purchase_date) AS…