anand m

anand m

  • 1.9k
  • 168
  • 11.1k

how to get Top 1 row in sql server 2000 version

May 12 2020 7:39 AM
Hello All,
 
How to get Top 1 rows in Sql server 2000 version we are using for your production server.
I need to get First row with out using Rowcount is there any option to bring to bring Top 1 row and Top 1 is not working in sql server 2000.
 
SET ROWCOUNT 1
SELECT errorcode,errordescription,name,logdate FROM msdb.dbo.sysdtspackagelog
WHERE WHERE[name] = 'ProjectModel_xfer2'
ORDER BY logdate
SET ROWCOUNT 0
 
Please help me. 
 

Answers (1)