topic Re: SQL query in QlikView

SQL query

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to extract data from SQL with max (YEAR) and max(month) at raw level extraction..

what shud be qyery for that?

pls suggest

Re: SQL query

giakoum — Tue, 04 Oct 2016 13:55:20 GMT

select * from table

where year(date) = (select max(year) from table)

or something similar

we need more details to answer that

Re: SQL query

jonathandienst — Tue, 04 Oct 2016 13:55:42 GMT

A subquery like this is one way:

SELECT Year,

Month,

...

FROM dbo.Table1

WHERE Year = Select(Max(Year) FRO dbo.Table1)

Re: SQL query

abhaysingh — Thu, 06 Oct 2016 13:51:30 GMT

Hi ioannis,

below suggested working fine

select * from table

where year(date) = (select max(year) from table)

but below desired query does not giving any output

select * from table

where year(date) = (select max(year) from table) and month(date) = (select max(Period) from table);

pls suggest..

Re: SQL query

its_anandrjs — Thu, 06 Oct 2016 14:12:40 GMT

Why not you try for incremental load logic for this.

Regards,

Anand

Re: SQL query

Anil_Babu_Samineni — Thu, 06 Oct 2016 14:28:56 GMT

abhay singh wrote:

but below desired query does not giving any output

select * from table

where year(date) = (select max(year) from table) and month(date) = (select max(Period) from table);

pls suggest..

From This, Might you require this

Load * From Table

where Year = Max(Year) and Month = Max(Month);

Re: SQL query

giakoum — Tue, 11 Oct 2016 07:35:04 GMT

Hi.

Most likely the format is different. Try using the to_date function to make them match.