This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Any idea why this would be invalid suiteql? I can do pkg.* and it works just fine.

```SELECT TOP(1) pkg.packagetrackingnumber
FROM Itemfulfillmentpackage pkg```


Do I really have to wrap this in a subquery this works? :confused:

```SELECT
  t.itemfulfillment
  , t.packagetrackingnumber
FROM (
  SELECT TOP(1) *
  FROM Itemfulfillmentpackage pkg
) t```

weird. I was going to toss out maybe it doesn't like the TOP function. I've run into weirdly random basic SQL functions that don't work in SuiteQL. No idea either why  wrapping it in a subquery would make a difference.

Is there another limiter method I can use besides top that should be used?

At the end of your query you can use fetch first 1 row only