SQL select * from column where year = 2010

by 
select * from mytable where year(Columnx) = 2010

Regarding index usage (answering Simon’s comment):

if you have an index on Columnx, SQLServer WON’T use it if you use the function “year” (or any other function).

There are two possible solutions for it, one is doing the search by interval like Columnx>=’01012010′ and Columnx<=’31122010′ and another one is to create a calculated column with the year(Columnx) expression, index it, and then do the filter on this new column

More Related Contents:

  1. Max sal to print base on manager_id
  2. Join vs. sub-query
  3. Refactor a PL/pgSQL function to return the output of various SELECT queries
  4. Can I use CASE statement in a JOIN condition?
  5. sql server 2008 management studio not checking the syntax of my query
  6. How do I write a full outer join query in access
  7. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  8. Select count(*) from multiple tables
  9. How to run a SQL query on an Excel table?
  10. conditional unique constraint
  11. REGEX to select nth value from a list, allowing for nulls
  12. Transpose rows into columns in BigQuery (Pivot implementation) [duplicate]
  13. LEFT OUTER JOIN in Rails 4
  14. Column ‘mary’ does not exist
  15. Which is better: Ad hoc queries or stored procedures? [closed]
  16. Group by alias (Oracle)
  17. GROUP_CONCAT in SQLite
  18. mysql automatically store record creation timestamp
  19. Subquery v/s inner join in sql server
  20. Curly braces in T-SQL
  21. Split comma separated values of a column in row, through Oracle SQL query
  22. oracle — Split multiple comma separated values in oracle table to multiple rows
  23. Pivoting in DB2
  24. How to compare sqlite TIMESTAMP values
  25. Find min and max for subsets of consecutive rows – gaps and islands
  26. Functions vs Stored Procedures
  27. What is the difference between cube, rollup and groupBy operators?
  28. How to get results in a custom order? [closed]
  29. How to perform a select query in a DO block?
  30. How to group by a Calculated Field

Leave a Comment