OT: Sybase Equivelant to MS SQL TOP?

• sthornton

  Ten Centuries

  Points: 1333

  More actions

  November 25, 2003 at 5:38 pm

  #83492

  Hi,

  I rountinely use SELECT TOP 10 * FROM TABLE to get an idea of what data I am dealing with in a table.

  I am doing a bit of a work on a Sybase Adaptive Server Enterprise and the same sql as I would use in MS, fails in Sybase.

  Is there a similiar function in Sybase SQL?

  Cheers,

• David.Poole

  SSC Guru

  Points: 75900

  More actions

  November 26, 2003 at 2:42 am

  #483676

  You have to do

  SET ROWOCOUNT 5

  SELECT ...etc

  Primitive

  There is a hell of a lot that Sybase doesn't seem to do. DBCC SHOWCONTIG, DBCC DBREINDEX etc.

  I've been trying to find out a way of defragging indexes and the only way that I have found of doing it is to drop and create the damn things as I had to do in the prehistoric days of SQL 6.5

  He was not wholly unware of the potential lack of insignificance.

  LinkedIn Profile

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  November 26, 2003 at 5:34 am

  #483698

  

  Sybase had TOP (and a synonym, FIRST) the last time I used it, several years ago. It did not have PERCENT or WITH TIES options, though.

  --Jonathan

  
  
  --Jonathan

• sthornton

  Ten Centuries

  Points: 1333

  More actions

  November 26, 2003 at 2:07 pm

  #483824

  Hi,

  Yep, This works :

  SET ROWCOUNT 5

  SELECT * from PATIENT

  However this :

  SELECT top 5 * from PATIENT

  returns the following error

  Server Message: Number 102, Severity 15

  Server 'hhie', Line 1:

  Incorrect syntax near '5'.