sql with ROWNUM criteria 1

[dbero]

I am unable to get the WHERE ROWNUM<=10 criteria to work.

SELECT QRYMaster.Status, QRYMaster.Region
FROM QRYMaster
WHERE ROWNUM<=10;

Can someone identify the problem?

Thank you

 

[lameid]

An error message would help.

Is ROWNUM in the output for QRYMaster?

Is ROWNUM a number?

Or are you trying something from SQL from another language and you want the top 10 rows?

SELECT TOP 10 QRYMaster.Status, QRYMaster.Region
FROM QRYMaster