Dear All,
What is the SQL syntax to get the first row of a query in Sybase ASE? Something likes in SQL Server 2000 :
SELECT TOP 1 Name
FROM User
Thanks.
Printable View
Dear All,
What is the SQL syntax to get the first row of a query in Sybase ASE? Something likes in SQL Server 2000 :
SELECT TOP 1 Name
FROM User
Thanks.
SET ROWCOUNT 1
SELECT Name FROM dbo.User
Hope this helps :D
sorry forgot to add...Rowcount will be set at the SESSION level so to remove execute a 'SET ROWCOUNT 0' statement. :)