Top 1 using SQL or Single Row

[Guest.Visitor]

Hi, How can I return only the first row matching to the criteria

---

Code

[K.Forsythe]

Top 1 using SQL or Single Row

At the end of your select add FETCH FIRST ROW ONLY. The TOP 1 syntax that you have seen on other platforms is not standard SQL syntax its an extension used on that platform.