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

5 votes170 views1 answer
Mysql count lines
SQL
0 vote156 views1 answer
Sql gather statistics to increase performance
SQL
0 vote196 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote177 views1 answer
Less than date query sqlachemy
SQL
0 vote158 views1 answer
SQL Server format datetime
SQL
10 votes138 views2 answers
Sql where clause multiple values
SQL
1 vote170 views1 answer
Where database run
SQL
1 vote164 views1 answer
Drop function
SQL
0 vote158 views1 answer
Stuff in sql server
SQL
5 votes124 views1 answer
Postgres upsert
SQL