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

7 votes164 views3 answers
Python and mysql connectivity
SQL
15 votes160 views3 answers
Find duplicate keys in mysql
SQL
16 votes155 views6 answers
Install sqlite3 python
SQL
0 vote170 views1 answer
Sql value exists in column
SQL
8 votes165 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote145 views1 answer
Group by 15 minute interval sql server
SQL
1 vote158 views1 answer
OstgreSQL version
SQL
6 votes148 views1 answer
Oracle trigger after logon on database
SQL
0 vote161 views2 answers
How covert into int in maria db
SQL
0 vote171 views1 answer
Time mysql w3
SQL