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

-1 vote304 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
-1 vote303 views1 answer
Io
SQL
14 votes339 views4 answers
Import database through command line
SQL
0 vote342 views3 answers
How to verify sequence result in oracle SQL
SQL
23 votes339 views4 answers
How to show all users in mysql
SQL
0 vote292 views1 answer
Generate sequence number in sql server
SQL
5 votes328 views1 answer
Oracle asynchronous update
SQL
0 vote317 views1 answer
How many rows affected in sqllite
SQL
1 vote314 views2 answers
How to enable error squiggles in vs code
SQL
0 vote331 views2 answers
Sql query inner join 3 tables
SQL