Some context, I am using postgres and I have a table that has items defined something like this: CREATE TYPE EventType AS ENUM ('published', 'unpublished'); CREATE TABLE items ( id integer NOT NULL, name varchar(40) NOT NULL, event EventType NOT…
Let’s say I want to show a list of companies, and also a first/random employee of that company. I could do something like: SELECT company.id, company.name, MIN(person.id) AS employee_person_id, MIN(person.name) AS employee_person_name FROM company LEFT OUTER JOIN person ON (person.company_id…
I am trying to call categories but only if a document is assigned to those categories. The document has the categories stored as a JSON type. In the WHERE it is only bringing back the rows that have document uids…
I have 2 MySQL tables, namely posts and votes The posts table contains articles published by authors (users). The votes table contains votes against the particular post by users. I'd like to get all posts that have or haven't been…
I have 3 tables in a database A, B and C which share the same column "name". B has an attribute "title" and C has an attribute "age". I am looking to write a SQL query where I will have…
How can I change this query [email protected]? $query = "select * from nozzle a left join nozzlereading b on a.id = b.nozzle and b.date=" . $date . " where a.meter=" . $meterid; $reading = DB::select($query); My models are Nozzle and…
so I have this left join LEFT JOIN LATERAL (SELECT d.country FROM db.patient_info d WHERE d.id IN (SELECT DISTINCT st.category FROM db.surgery_types st, db.surgery_record sr WHERE sr.id = st.surgery_record_id AND sr.surgery_type_id = m.id) ORDER BY d.priority, d.country LIMIT 1 )…
Websites: website_Id website_name 1 website_a 2 website_b 3 website_c 4 website_d 5 website_e Fixtures: fixture_Id website_id fixture_details 1 1 a vs b 2 1 c vs d 3 2 e vs f 4 2 g vs h 5 4 i…
I have this query in Postgres: Select "Charges"."saleAmount", "Charges"."buyAmount", "Operations"."id" From "Charges" Left Join "Operations" On "Operations"."id" = "Charges"."operationsId" Order By "Operations"."id" saleAmount buyAmount id 200 NULL id1 300 500 id2 0 100 id3 I need to transform it: Add…
I have three tables that describe data where there are some main things. Each thing can have several categories below it, and each category can have multiple segments. main main_id main_name 1 bla 2 blub categories cat_id main_id category_name 4…