I am trying to return a list of brands that do not have a specific product ID. Using the following SQL: SELECT Brands FROM AllCustomers WHERE ProductID NOT IN (SELECT ProductID WHERE ProductID ='10235') Is there a more effective way…
I'm trying to insert data to two different table simultaneously. If failed , then roll back the data. And I try to google, and found some solutions: 1.Use data transactions. 2.Create a extra table then join two table. 3.Create a…
Suppose I have a table (DeliveryEvent) like this grouped by delivery_id, where event_type 2 is an event of 'scheduled', 3 is an event of 'unscheduled', and 4 is an event of 'completed': id created event_type delivery_id extra 1 2022-10-27 18:04…
I created SQL query which should count the number of e-mails sent after 20.12.2022 for each user_id from ACTIONQUEUE table. My query counts everything correctly for all users, but it doesn't returns 0 in the table for the users with…
If I have two tables table A and table B, for a given name, how can I get the latest for table A only if it's newer than the latest date in table B or the name does not exist…
I have a column 'zips' with type 'text' in the table parcels. User can fill either a single zip code, OR multiple comma separated zips, OR a range of zips separated by a hyphon. Examples of possible datas are. '10001'…
I have a table in postgresql table which contains IN / OUT timestamp of several employees. I want to derive a table with IN and OUT timestamp of the day for each employee in same rows with null value if…
I have this PostgreSQL table for storing words: CREATE TABLE IF NOT EXISTS words ( id bigint NOT NULL DEFAULT nextval('processed_words_id_seq'::regclass), keyword character varying(300) COLLATE pg_catalog."default", ); insert into words (keyword) VALUES ('while swam is interesting'); CREATE TABLE IF NOT…
I have data in Telephone table, something as below: ID area exch line ext tel_type_cde tel_seq_num modified_dttm 1234 482 876 789 1234 0 0 01-01-2023 1234 483 877 123 0 1 01-02-2023 1234 123 234 456 1234 1 0 01-01-2023…
I am using MySQL and am trying to replace/fill all null values in a column with the previous non-null value present within the same column. I tried using the lag() windows function, but I don't seem to get the expected…