SQL Query with count conditions

Question

I'm new working with databases and i have the following question.

I have a table with the columns: input, output and type.
The column input and output are products ids and the column type only have 3 values 'techno','bio' or 'production'. I have 1000's of records.
Is it possible to do a query to find the inputs that have more than one record with 'production' type?

I work with SQLite3 on python. Thanks! :)

Darshit Kothari · Accepted Answer · 2020-09-07 16:20:44Z

1

From what I understand, input column in your database table has product id and can be the same across several rows. If that's the case, then the query you're looking at should be something like this:

select input, count(type) from table_name where type = 'production' group by input having count(type) > 1

answered Sep 7, 2020 at 16:20

Darshit Kothari

1315 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query with count conditions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related