How to insert MAX (text) as WHERE clause?
I should be searching based on two WHERE clauses at the same time. One is a simple clause, the other is MAX (text). How to solve?
x = cursor.execute('SELECT product FROM electronics WHERE brand = ? AND MAX(price)' [combo_brand])
Price
is a column of a database. I want to take the highest value of the column records. I would like to select the product with the maximum price, and search by it and by brand at the same time.
I am getting this error:
TypeError: string indices must be integers