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 vote368 views1 answer
Postgres drop type
SQL
7 votes413 views3 answers
Sql update where id
SQL
0 vote346 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote359 views1 answer
Hive batch drop table
SQL
1 vote368 views1 answer
Get table column names sql ssms
SQL
3 votes379 views3 answers
Stop mysql ubuntu
SQL
25 votes398 views4 answers
Sqlserver add column
SQL
0 vote383 views1 answer
How to generate ids in sql
SQL
0 vote381 views1 answer
Sql server insert inner join
SQL
0 vote384 views1 answer
Query to remove duplicate rows from a table
SQL