How to count the number of identical rows in a DB (flask-sqlalchemy)?

N

near_you122022-04-10 13:05:27

SQLite

near_you12, 2022-04-10 13:05:27

For example, I have a table that is written from the Flask

title id
first 1
second 2
third 3
first 4
third 5

I just need to output:
first -2
second -1
third - 2

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

I

ivanfenenko2014-04-08 16:29:02

How to store float[][] in SQLite (Android)? 2Reply

S

Sash0k_k2014-04-09 11:03:36

What is the best way to store the MAC address in the database? 4Reply

T

true2021-12-30 21:29:05

Where is the error in the database query? 2Reply

T

true2021-12-31 23:11:01

Is it possible to not specify the data type in a sqlite table cell? 2Reply

N

NeoZeed2014-04-25 13:57:20

Cyrillic SQLite in Visual Studio 2010 console 1Reply

Didn't find what you were looking for?

Ask your question