I have two tables A and B each with unique constraints for appid and name columns to ensure name is unique for each appid. However, now I also need to ensure that name value is unique across the both tables.…
I am using MySQL and facing a question. I want to count the consecutive occurrence of type based on each ID and select out only the IDs with more than 3 times of error-type. Additionaly, based on the above result,…
I am trying to get a table of an average for a column, across multiple rows (if that makes sense). For example, in the table below, I need to group the postcodes (as there can be more than 1 suburb…
I am new to joining two tables in PostgreSQL. Table 1: O_REMEDY_PEOPLEGROUP manager_name manager_hierarchy farhanpat raju jacob watson soumyvant neha william amitk piyush shawn brian david warner Table 2: Org_details org_name vp_details org1 jacob org2 piyush org3 neha We want…
I am performing group by to get the count of every individual value along with the total count. Data, It is very easy to get the count of individual columns using below queries, select name, colour, count(1) from table group…
I want to select data from two tables, category and sub_category. But I only get the column names of category. I want both category and sub_category. Here is the result: { category_id: 3, category: 'GARDEN' }, { category_id: 6, category:…
I would like to perform an operation that aggregates the values of one column based on combination of values in two other columns irrespective of which column they show up in. For example, given this table: a b 10.0 <-…
I am pretty new to this topic. So i have this table: Table "public.client" Column | Type | Collation | Nullable | Default --------------------------+-------------------+-----------+----------+--------- contact_phone | character(11) | | not null | status | character(11) | | not null |…
Getting Connection Lost in coorelated queries. select emp_no,salary from salaries e where 2 = (select count(distinct salary) from salaries p where p.salary>e.salary); I tried this to get second highest salary but its giving me sql connection lost every time. All…
UPDATE accounts SET lastSerialChange = CURRENT_TIMESTAMP WHERE username = 'Jayden'; UPDATE accounts SET serialChanges = '[{"serial":"D06ACE5BBE90E803590D1691FB9254B3","reason":"test","date":1695495618004}]' WHERE username = 'Jayden'; INSERT INTO serial_requests (username, serial, reason, requestedAt) VALUES ('Jayden', 'D06ACE5BBE90E803590D1691FB9254B3', 'test', 1695495618004); I am querying my database with the above,…