<div>
SELECT TOP 10 * FROM T<br />
<br />
try this<br />
<br />
<br />

</div>


<div>
Does anyone know how to configure ASE to support CIS rpc procedures?
</div>


Does anyone know how to configure ASE to support CIS rpc procedures?

<div>
SybaseUk<br />
<br />
The way it works is, you need to close the question, award points, and ask a new question. &nbsp;You will get a much better response, the only people watching this thread are those who have chosen to watch an &quot;Oracle Rank()&quot; question.<br />
<br />
Cheers<br />
<br />

</div>


SybaseUk

The way it works is, you need to close the question, award points, and ask a new question.  You will get a much better response, the only people watching this thread are those who have chosen to watch an "Oracle Rank()" question.

Cheers



<div>
<div class="content wysiwyg-content">
Hi experts, <br />
<br />
Is there a way of converting (or re-writing) an ORACLE RANK() function into Sybase ASE T-SQL?<br />
<br />
I know this is possible in Sybase IQ but I have not seen this function in ASE and was wondering how I could get a query containing RANK to work in Sybase ASE. <br />
<br />
Thanks,
</div>
</div>


Hi experts, 

Is there a way of converting (or re-writing) an ORACLE RANK() function into Sybase ASE T-SQL?

I know this is possible in Sybase IQ but I have not seen this function in ASE and was wondering how I could get a query containing RANK to work in Sybase ASE. 

Thanks,

Oracle RANK() function to Sybase ASE

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.