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

0 vote155 views1 answer
Sql query to select even numbers
SQL
0 vote111 views1 answer
Convert sql server guid to varbinary
SQL
3 votes130 views4 answers
Truncate syntax in sql
SQL
17 votes145 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote131 views1 answer
Sql statement show all emails with dome
SQL
0 vote132 views1 answer
Sqlite explain plan
SQL
1 vote105 views1 answer
How to check the mysql version mac
SQL
0 vote113 views4 answers
Database stuck at restoring state
SQL
0 vote111 views1 answer
Postgresql copy backup table
SQL
0 vote112 views2 answers
Soql last year
SQL