Thursday, January 3, 2008

Sybase Annoyances

One of the things that I really hated about Sybase is its lack of support for the use of the keyword top in subquries, for example:
Select
field1,
(select top 1 field1 from table2
where id = table1.id) myfield
from table1

This works in SQL Server but not in Sybase.

This is as of Sybase ASE 12.5, I don't know if this changed in Sybase ASE 15, so, if you have any idea bout it please share this with us in the comments section.

0 comments: