This one is the most efficient SQL query, especially if the WHERE clause is covered by an index.
Greater than, less than: >, >=, <, <=, BETWEEN
Note that Microsoft SQL Server rewrites a BETWEEN to >= and <=.
Note that if you start with a wildcard, then SQL Server will do a table scan, whether there is an index or not, such as: LIKE '%E'.
Different from: <>, NOT
Note that Microsoft SQL Server rewrites a NOT to <>.
Note that SQL Server will do a table scan, whether there is an index covering the WHERE clause or not.
So, use = as much as possible and use <> as least as possible.