topic Re: SQL SELECT TOP 1000 in QlikView

SQL SELECT TOP 1000

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: SQL SELECT TOP 1000

Clever_Anjos — Fri, 05 Aug 2016 14:04:01 GMT

Would you mind posting here your SQL?

Re: SQL SELECT TOP 1000

vishsaggi — Fri, 05 Aug 2016 14:10:23 GMT

May be this?

SQL SELECT TOP 1000

Col1

,Col2

,Closed_at

FROM <Table Name>

WHERE Year(Closed_at) >= 2015;