pick record from field

[devender]

Hi,

I have a field with 120 records, now i have to pull only 7 records from sql field.

[MayilVahanan]

Hi

Try like below

First 7 SQL SELECT * from urtablename;

or
SQL SELECT top 7 * from urtablename;

[devender]

Hi,

They are not in order. i just have the record names and i have to fetch with the names.

[MayilVahanan]

HI

In that case, you need to use where condition like

SQL Select * from urtablename where names in ('x','y','z'); 

in Qlik

Load * from urfile where match(names, 'x','y','z');