ORY
Reputation: 413
Sqlite query Select only when equals two values
"SELECT ? FROM TableSales....
I have two Columns, one is for Manufacturer and the other one is for Model. I want to count how many times they exists in the table. The problem is to use a filter which only counts those, where the Manufacturer and the Model column are equal. Cause it could happen that the Model Column or the Manufacturer Column are equal but not both together.
Upvotes: 0
Views: 108
Answers (1)
FBidu
Reputation: 1012
It seems to me that you can accomplish the task with this code:
SELECT COUNT(*) FROM TableSales WHERE Manufacturer == Model
Upvotes: 1
Related Questions
- SQL Query - Check for Two Distinct Values
- Compare two values with other two specific values in SQL
- How to write a SQLite SELECT query with WHERE clause to get both matched and unmatched values
- Select rows that have two different values in same column
- SQLite select row with multiple condition from other table
- sqlite - where two records exist with a different value in certain column, only select certain record
- SQLite compare single value to multiple values
- SQL - Select items where value equals multiple values
- Query two same column
- SQLite SELECT equal to one of two values