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 vote205 views1 answer
Add column to table with default value plsql
SQL
0 vote209 views2 answers
Mysql regexp match word
SQL
0 vote236 views1 answer
No query unable to fetch row sqlite
SQL
0 vote241 views1 answer
Cahnge column name apex oracle
SQL
0 vote210 views1 answer
Oracle synonym procedure
SQL
0 vote246 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote217 views1 answer
Alter owner in PostgreSQL
SQL
0 vote216 views1 answer
Postgresql isnull with max
SQL
0 vote220 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
1 vote200 views1 answer
Show indices in mysql table
SQL