SQL Script in Qlikview - Where Clause and Top1

Fri, 27 Jul 2012 06:33:16 GMT

Hi I have the following code snippet in SQL and am looking to use it in my QLikview script.

however when applying directly into SQL it returns an error.

1. How to use a clause statement WHERE ?

2.How to use function TOP in script?

Any tips would be appreciated;

See code snippet below;

SELECT

TOP 1 updated, updatedby
From dboxxxxxx ."tblCase_CaseHistory";
WHERE caseid = ärendeid AND statusid IN (avslutadstatusid)

Re: SQL Script in Qlikview - Where Clause and Top1

perumal_41 — Fri, 27 Jul 2012 06:45:41 GMT

try below script

First (1) Select * from Orders