Learn Little bit More

* Use with(no lock ) for every table  while selecting records in Stored procedures ,views and functions . * Use limit if you have more records. * Create index on a table as per our requirements.

Today we are going to learn two useful keywords from SQL . 1.ALL It's equivalent to AND  condition. SELECT * FROM EMPLOYEE WHERE AGE > ALL (25,30,35) 2.ANY   It's equivalent to OR  condition. SELECT * FROM EMPLOYEE WHERE AGE > ANY(25,30,35)