Select First row SQL Query

[Manoj Chaurasia]

We are using a SQL Query to get some data from our ERP system, but the results shows mutiple rows.

I want to show only the first row of the results.

Query looks like:

SQLQUERY(S12,"SELECT id-cdads FROM data.pub.""ba-012"" WHERE ""Zoeksleutel"" = '%s'")

How can I select the first row of the field id-cdads

[Wes Couturier]

Hello Stefan,

 

If you're not looking for any particular record from that table, have you attempted to use a "Select Top 1 id-cdads ..." SQL query

 

See the following Stack Overflow page for a refernce: https://stackoverflow.com/questions/1891789/sql-select-first-10-rows-only

 

If you're still stuck, can you tell us what is your ERP system Does it use SQL Server

 

Thank you.