topic First (100) SQL Select Distinct in QlikView

First (100) SQL Select Distinct

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

I would like to limit sql load to 1000 rows, that will really help me test, the SQL database is very large.

The code below is pulling all the data from sql, how can I limit this before a Qlikview preceding load?

Load *;

First (100) SQL SELECT DISTINCT * FROM xyz;

Thanks

Neil

Re: First (100) SQL Select Distinct

Anonymous — Thu, 13 Oct 2016 19:40:02 GMT

You can debug and limit the load on 100 rows.

Re: First (100) SQL Select Distinct

sunny_talwar — Thu, 13 Oct 2016 19:40:51 GMT

May be this:

SQL SELECT DISTCINT *

FROM xyz

WHERE ROWNUM <= 1000;

Other options can be found here: SQL SELECT TOP, LIMIT, ROWNUM

Re: First (100) SQL Select Distinct

benvatvandata — Thu, 13 Oct 2016 19:48:38 GMT

Similar to what Sunny T said, try:

LOAD *;

SQL SELECT DISTINCT TOP 1000 *

FROM xyz;

Re: First (100) SQL Select Distinct

Anonymous — Thu, 13 Oct 2016 20:03:00 GMT

Or you can do

Load *;

SQL

SELECT DISTINCT top(1000) * FROM xyz;

Re: First (100) SQL Select Distinct

Clever_Anjos — Thu, 13 Oct 2016 23:14:41 GMT

IF you´re using:

Oracle:

SELECT * FROM TABLE where ROWNUM < 100;

SQL Server

SELECT top (100) * FROM TABLE

MySQL

SELECT * FROM TABLE limit 100

Re: First (100) SQL Select Distinct

beck_bakytbek — Fri, 14 Oct 2016 09:23:01 GMT

Hi Neil,

Are you working with SQL-Server? From wich Database do you connect your tables?

Re: First (100) SQL Select Distinct

vcanale — Fri, 14 Oct 2016 09:27:04 GMT

Hi,

You can use the First prefix:

Limited Load and the First Prefix

Re: First (100) SQL Select Distinct

Anonymous — Fri, 14 Oct 2016 09:32:17 GMT

To answer your question:

To do it with preceeding load:

Tablename:

First 100

Load *;

SQL SELECT DISTINCT * FROM xyz;

What Db are you using?

Re: First (100) SQL Select Distinct

Anil_Babu_Samineni — Fri, 14 Oct 2016 09:39:43 GMT

Another way could be this

=if(aggr(rank(sum(DISTINCT Sales)),Dimension)<=100,Dimension)

Re: First (100) SQL Select Distinct

awhitfield — Fri, 14 Oct 2016 09:46:31 GMT

Hi Neil,

makes sense to do this as a 'Limited Load' using the debugger, this sort of scenario is exactly what it's there for!

HTH

Andy