SQL SELECT TOP 1000

[#1]

I am trying to get the top 1000 rows in a large data set for only the year 2015 and 2016.  The field that has the close date is closed_at and the values are formatted as a date and a time. (00/00/0000 00:00:00 AM) SQL Select TOP 1000 works to get 1000 rows of data, but now I just need the rows that have a close date of 2015-2016.

[Clever_Anjos]

Would you mind posting here your SQL?

[vishsaggi]

May be this?

SQL SELECT TOP 1000

                      Col1

                     ,Col2

                     ,Closed_at

FROM <Table Name>

WHERE Year(Closed_at) >= 2015;