Revolving around the core of technology
Hi,
Anyone know of a function in winsql similar to ROW_NUMBER() OR RANK()? I am trying to find limited count results out of many for given values in where clause.
-Udayan
Udayan,
WinSQL does not have any syntax of its own. Instead, it inherits the syntax from the back-end you are connecting to. For example, if you're connecting to Oracle, you must use the SQL grammar required by PL/SQL. Similarly, when connecting to MS SQL Server, you must use TransactSQL.
Therefore, refer to the documentation of your back-end database to see if that supports ROW_NUMBER() or RANK() functions.