Explanation of 1=1 clause of SQL [duplicate]

Question

In a lot of SQL examples , while copying one table's structure without the data , we see the use of AND 1 = 1 clause. What exactly is this 1=1 and is there any other thing similar to it in SQL or any other DBMS.

Bud Damyanov · Accepted Answer · 2013-03-19 10:00:45Z

1

It is a SQL language construct, which evaluates always to true (because 1 is always equal to 1). It is used mostly when generating dynamic SQL queries for developer`s convenience.

answered Mar 19, 2013 at 10:00

Bud Damyanov

32.1k7 gold badges47 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

A4L Over a year ago

... for not having to check whether to add an AND before first condition or not :)

Aditya Kaushik Over a year ago

@A4L Thanks for your answer. I also found some new facts in the questions suggested above. So I request you to vote to delete this question.

Collectives™ on Stack Overflow

Explanation of 1=1 clause of SQL [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related