What does the WHERE clause "1=1" mean in SQL?

When you use 1=1 as the condition, it essentially means where true . Since the equality condition 1=1 is always true, the WHERE clause does not filter out any records. In other words, it returns all the records from the table without any filtering. Lees verder »