Order of WHERE clause is affecting result

Order of WHERE clause is affecting result

References

Reference NO 1

http://stackoverflow.com/questions/15204968/order-of-where-clause-is-affecting-result

Reference NO 2

http://stackoverflow.com/questions/4035760/does-the-order-of-fields-in-a-where-clause-affect-performance-in-mysql

Reference NO 3

http://dba.stackexchange.com/questions/1792/in-mysql-does-the-order-of-the-columns-in-a-where-clause-affect-query-performan

Reference NO 4

http://www.bigresource.com/MS_SQL-Rank-and-using-WHERE-clause-on-results-Zsxlnb2U.html

Reference NO 5

http://blog.sqlauthority.com/2009/03/15/sql-server-interesting-observation-of-on-clause-on-left-join-how-on-clause-effects-resultset-in-left-join/

Reference NO 6

http://docs.doctrine-project.org/projects/doctrine1/en/latest/en/manual/dql-doctrine-query-language.html

Reference NO 7

http://dev.mysql.com/doc/refman/5.0/en/group-by-extensions.html

Reference NO 8

#EANF#