"Where" condition in SQL statement

[anandcv]

In "WHERE" clause of SQL statement, if there are more than one conditions then why one of them is ..." 1 = 1"

for example
select * from student_info
WHERE 1 = 1
AND student_id = 10
AND STANDARD = '9th'
AND MARKS_OBTAINED >=90;


Thanks
Anand

 

[mdwyer]

This is not necessary for the statement to run. I have done this to allow for dynamic construction of statements, including manual cutting and pasting of conditions. Each clause can be built as an "AND" without the logic of determining if the (first) WHERE clause is present.