I hope someone can help with this! I've used the following query to count the distinct values in column2 and column3 and filter the results: SELECT column1, COUNT(DISTINCT(column2)), COUNT(DISTINCT(column3)) FROM table1 GROUP BY column1 HAVING COUNT(DISTINCT(column2)) > 1 OR COUNT(DISTINCT(column3))…
I have a table source_flight_destination like this ID Flight source destination 1 Indigo II BB 2 Air Asia AA II 3 Indigo BB JJ 4 spice jet SS BB 5 Indigo JJ SS 6 Air Asia II KK 7 spice…
I have table2 contains around 26 columns & 2mln rows. a b c d e f g h i j k l m n o p q r s t u v w x y z 18 2 2 22…
Let's say I have the following PostgreSQL table called products which has millions of records: CREATE TABLE IF NOT EXISTS mytable ( id serial NOT NULL PRIMARY KEY, label VARCHAR(50) NOT NULL, info jsonb NOT NULL, created_at timestamp NOT NULL…
I'm new to SQL queries so hopes this question isn't stupid. I got two tables like this: Table 1: Name Value Count global g 1 domain x 2 domain y 1 agg ba 1 Table 2: Name Value Count global…
I have a mongo collection with documents containing arrays: { item: "journal", qty: 25, tags: ["blank", "red"], dim_cm: [ 14, 21 ] }, { item: "notebook", qty: 50, tags: ["red", "blank"], dim_cm: [ 14, 21 ] }, { item: "paper",…