Flask sqlalchemy remove duplicates

mylist = db.session.query(User.name).all() # get all user.name from db
mylist1 = len(list(dict.fromkeys(mylist))) # remove the duplicate then use len() to find total

Similar codes

12 votes376 views6 answers
Distinct in sql server
SQL
0 vote323 views1 answer
Select from another database
SQL
0 vote329 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote299 views1 answer
Postgres create database if not exists
SQL
1 vote346 views1 answer
Postgresql escape single quote
SQL
3 votes328 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote331 views1 answer
Mssql now diff 90 day
SQL
0 vote366 views1 answer
Soql queries for not contact related account records in salesforce
SQL
3 votes347 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote338 views1 answer
Postgres clear table
SQL